public bool UpdateOtherSubTask(OtherSubTaskModel subTask)
{
bool isSuccess = true;
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["DBConnection"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "UpdateOtherSubTask";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OtherTaskId", subTask.OtherTaskId);
cmd.Parameters.AddWithValue("@OtherSubTaskId", subTask.OtherSubTaskId);
cmd.Parameters.AddWithValue("@TaskName", subTask.TaskName);
cmd.Parameters.AddWithValue("@IsCompleted", subTask.IsCompleted);
cmd.Parameters.AddWithValue("@ActualEndDate", subTask.ActualEndDate);
cmd.Parameters.AddWithValue("@ActualStartDate", subTask.ActualStartDate);
cmd.Parameters.AddWithValue("@AddedBy", subTask.AddedBy);
cmd.Parameters.AddWithValue("@AmountSpent", subTask.AmountSpent);
cmd.Parameters.AddWithValue("@AssignedUserContactNumber", subTask.AssignedUserContactNumber);
cmd.Parameters.AddWithValue("@AssignedUserId", subTask.AssignedUserId);
cmd.Parameters.AddWithValue("@AssignedUserName", subTask.AssignedUserName);
cmd.Parameters.AddWithValue("@Comments", subTask.Comments);
cmd.Parameters.AddWithValue("@Description", subTask.Description);
cmd.Parameters.AddWithValue("@Estimate", subTask.Estimate);
cmd.Parameters.AddWithValue("@ExpectedEndDate", subTask.ExpectedEndDate);
cmd.Parameters.AddWithValue("@ExpectedStartDate", subTask.ExpectedStartDate);
cmd.Connection = conn;
conn.Open();
isSuccess = Convert.ToBoolean(cmd.ExecuteScalar());
conn.Close();
}
}
}
catch (Exception ex)
{
//LogError(ex);
isSuccess = false;
}
return(isSuccess);
}
