Good Morning,
I'm having a quite confusing issue..
In a webform i'm having the following command:
string SqlChangeStatusRequirement = "UPDATE [ITRequirementRequirements] SET [Status] = @Status, [StatusLastChange] = GETDATE(), [StatusLastChangeUser] = @CurrentUser, [ApproverComment] = @ApproverComment WHERE [ID] = @RequirementID";
try
{
using (SqlConnection Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["eFormsConnectionString"].ConnectionString))
{
SqlCommand UpdateStatus = new SqlCommand(SqlChangeStatusRequirement, Connection);
UpdateStatus.Parameters.AddWithValue("@Status", NewStatus);
IIdentity HttpUser = HttpContext.Current.User.Identity;
string LogonName = HttpUser.Name.Substring(HttpUser.Name.IndexOf("\\") + 1);
UpdateStatus.Pa ...
Go to the complete details ...