Comments by xhon - CodeProject

xhon 23-Jan-21 12:32pm View

Thanks Peter.
As regards the event handler, I assume that I also need to specify this.OnLoad, is it correct? Or is there a way to tell JS that it's an OnLOad event from CRM/Ribbon workbench configuration?

I update the code as below, I'm not sure if I'm using the override of the OnLoad method correctly here:

function hideButton(executionContext) {
var executionContext = executionContext.getFormContext();
var formContext = executionContext.getFormContext();
var state = formContext.getAttribute("statecode").getValue();

this.OnLoad(executionContext){
if (state.getValue() == 1) {
document.getElementById("button_id").setDisabled(true);
}
else {
document.getElementById("button_id").setDisabled(false);
}

}

}

xhon 22-Jan-21 12:29pm View

Hi, ok, I corrected the tags, thanks.

xhon 4-Dec-20 7:24am View

thank you for commenting. I implemented the following action on my Controller:

public ActionResult getByDirector()
{
List<movie> movies = _movieProxy.GetByDirector();
return View (movies);
}

Then I added the following in my Index View, a JS function which calls the method above:

function searchFunction()
{
var url = "@Url.Action("GetByDirector");

$.get(url, function (data)
{
$("#newDivTag" ).html('$' + data); // I created this new div to contain the results
});
}

Then I wrote the following:

$.ajax({
Type: "GET",
contentType: "application/json; charset=utf=8",
url: "/MovieMvc/GetByDirector",
success: function (data) { successCallBack(data); },
error: function(data) { failureCallBack(data); }
});

Does it make sense?

xhon 2-Dec-20 8:29am View

thanks

xhon 30-Nov-20 13:14pm View

I know how to implement constructor and method injection (I used constructor injection in the code above, see the second block of code that I posted before), I apologize if my question wasn't clear. My Q was about the difference between using dependency injection and using dependency injection with Unity, I don't understand what would be the benefit of using Unity, configuring the classes in Unity to inject them, as it seems to me it can be even done without (As you said, DI can be as simple as having a constructor accepting parameters)

xhon 30-Nov-20 12:38pm View

Thank you for answering. Can you please explain to me the meaning of this conditional expression? -->

m => m.Title.IndexOf(selectedTitle, StringComparison.CurrentCultureIgnoreCase) != -1)

xhon 27-Nov-20 8:39am View

I tried to solve it this way: I moved the unityConfig file from one folder to the other, I added all references and now I did'n get compilation errors, but when I open the view in the browser I get the no parameterless constructor defined error. I'm pretty sure it's related to Unity configuration because I got the same error while trying to use a parametrized constructor for the controller before installing Unity

xhon 27-Nov-20 8:29am View

thanks for commenting, I solved the previous issue (it was not related with unity) but I'm having this new one: I uninstalled Unity package from all projects and now I reinstalled it for the web app project but UnityConfig file has not been created...

xhon 27-Nov-20 7:26am View

thanks for helping! I succeeded in moving unity packages in the new project but now I'm having the following error: in some of the .cshtml razor views the @Html is no more recognized...May it be related to the mentioned procedure someway?

xhon 26-Nov-20 8:22am View

Deleted

How can I refer to movies in the implicit operator? The ListOfMovies class is implemented in a different file...
I also tried to use the first option you suggested but Movies is not recognized inside the implementation of the action (I already included the "using" statement to refer to the parent folder)

xhon 19-Nov-20 9:16am View

thanks a lot for your answer. I edited my question (now I am more focused on how to manage the resources in my rest service project implementation)

xhon 11-Nov-20 7:50am View

I solved it! It depended on having set NOCOUNT ON in my SP. Now I commented that statement and the ExecuteNonQuery returns the expected number. Thanks for the tips

xhon 11-Nov-20 7:12am View

I solved the problem!:) some items could not be deleted because of referential integrity, I edited my db and now everything works fine (but I still don't understand why ExecuteNonQuery returns -1)

xhon 11-Nov-20 6:32am View

ExecuteNonQuery returns -1.
UPDATE: I inserted new items to the db from C# and I succeeded in deleted them by using this method (ExecuteNonQuery stills returns -1 and ExecuteNonQuery() == 1 still returns false) BUT the deleting operation fails when I tried to delete the items already in the db (i.e. those rows created within Sql Management Studio, not added from my application)... I guess the problem could be in a non-correspondence between the properties of the columns in the DB and the attributes of the corresponding entities, but at this point I wonder why ExecuteNonQuery return -1 (shouldn't it be 1?) even when the deleting operation is successful.

xhon 11-Nov-20 5:34am View

no, I don't pass the parameters manually, I pass them directly from the C# method. I checked them by storing the results of the "cmd.Parameters.Add" statements on variables (one for each parameter added) and they are correct. I assigned the result of "cmd.ExecuteNonQuery == 1" to the variable "result" and the method returns it and it's false (so the result of ExecuteNonQuery==1 is false) instead than true

xhon 11-Nov-20 4:15am View

the stored procedure works when I call it from the Sql Server Manager, whereas the method in Visual Studio where I call the stored procedure doesn't return the expected result

xhon 11-Nov-20 3:04am View

my stored procedure works, it's just that the C# method returns false instead than true because the item has not been deleted (I can delete it by calling my stored procedure on my db manager application though)

xhon 9-Nov-20 12:30pm View

I have a doubt: can we call a view by using a variable or it's not allowed because it doesn't output a scalar value?
Given that I can't write the following code because I should provide a data type for the variable and the table doesn't have a datatype, is there any other way to provide a variabile?

DECLARE @myView = name_Of_the_View;
S£LECT * FROM @myView

I suppose I should

xhon 9-Nov-20 11:58am View

Thank you very much! I was wondering why shall we use variables to set the returned value instead than writing the name of the column: if I substitute the parameter @NumberOfCopis this way: 'return Movie.NumberOfCopies' I'm told that the multi-part identifier 'Movie.NumberoOfCopies' could not be bound, what does it mean and why is so important to use parameters within a sql function? It depends on the necessity of keeping track of the object data in order to be able to output their value, right?

xhon 9-Nov-20 7:46am View

Deleted

What if I wanted to do a single stored procedure by passing a parameter to tell to do the insert if the parameter is equal to 'insert', otherwise to delete the movie if it's equal to 'delete'?

xhon 6-Nov-20 10:51am View

OK thanks, I'm gonna drop the table which contains the foreign key and create it again by naming the referring column differently...Or there is a way to avoid dropping the table? Can I use a variable for that column name inside the function maybe?

xhon 6-Nov-20 10:40am View

I got this other error message:
"Column names in each view or function must be unique. Column name 'IDMovies' in view or function 'ReservationDetails' is specified more than once."

xhon 6-Nov-20 9:58am View

I have a couple of doubts: when you wrote :
RETURN IsNull((@NumberOfCopiesIfMovieExists, 0)

is like to say :"return values by default AND return 0 if the NumberOfCopies is 0", right?

And what if I wanted to assign an alias to the output column?

xhon 6-Nov-20 9:44am View

Deleted

I got the following error:

Cannot find either column "Movies" or the user-defined function or aggregate "Movies.ReturnNumberOfCopies", or the name is ambiguous.

xhon 6-Nov-20 8:00am View

thank you very much!

xhon 6-Nov-20 6:00am View

I edited it, but nothing changed, the column name is still invalid

xhon 5-Nov-20 11:38am View

Than you very much. In your opinion could I obtain the same result by using an outer join?

xhon 5-Nov-20 8:19am View

what if each movie has N copis and I want to show the director, the total number of copies, the number of available ones and the number of copies which are currently reserved?
I'm trying to do this:

SELECT
Director
Number_of_copies, (
SELECT
Number_of_copies
FROM
Movies m
INNER JOIN
ReservationsOfMovies r
ON
r.IDMovie = m.IDMovie
WHERE
@Today BETWEEN StartDate AND EndDate

)
AS Currently_Reserved,

(
SELECT
Quantity
FROM
Movies m
INNER JOIN
ReservationsOfMovies r
ON
r.IDMovies = m.IDMovies
WHERE
@Current_Date > EndDate

)
AS Currently_Available

FROM Movies
GROUP BY Drector, Quantity

xhon 5-Nov-20 7:13am View

Hi, thanks for your answer. How can I put both in one select?

xhon 4-Nov-20 6:37am View

thanks! What if I wanted to select all the Directors (Name and Surname) who made more than 10 movies?
I would like to order them by the number of books they wrote, from the maximum to the minimum.
I did the following:
SELECT CONCAT (DirctorName, DirectorSurname) AS Director
FROM Movies
WHERE COUNT(*) > 10
ORDER BY COUNT(*) DESC

xhon 4-Nov-20 5:50am View

ok, I created the tables from scratch and now it works. I still have the problem 2, though...I can't add a default constraint to the Date2 in order to force it to be Date1 + 30 days

xhon 4-Nov-20 2:26am View

I also tried this:

ALTER TABLE TableName
ADD CONSTRAINT CK_TableName_Date2Is5DaysAfterSTartDate
        CHECK (Date2= DATEADD(day, 5, StartDate));

I got this error:

The ALTER TABLE statement conflicted with the CHECK constraint "CK_TableName_Date2Is5DaysAfterSTartDate".

Comments by xhon (Top 32 by date)