public static DataSet TaskUpdate(UpdateTaskManagement updateTask)
{
DataSet ds = new DataSet();
MySqlConnection conn = connstring;
try
{
conn.Open();
string stm = "spTM_UpdateTask";
MySqlCommand cmd = new MySqlCommand(stm, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd = mySqlCommandParameters(cmd, updateTask); // setting values to the procedure parameters
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(ds, "Data");
return(ds);
}
catch (Exception ex)
{
Log(ex, System.Reflection.MethodBase.GetCurrentMethod().Name);
throw ex;
}
finally
{
conn.Close();
}
return(ds);
}
public IHttpActionResult TaskUpdate(JObject requestParams)
{
var data = "";
var identity = MyAuthorizationServerProvider.AuthenticateUser();
if (identity != null)
{
try
{
UpdateTaskManagement task = requestParams.ToObject <UpdateTaskManagement>();
task.Param_CompID = identity.CompId;
task.Param_UserID = Convert.ToInt32(identity.UserID);
var ds = TaskBL.TaskUpdate(task);
data = Utility.ConvertDataSetToJSONString(ds);
data = Utility.Successful(data);
#region Activity Log
ActivityLog objlog = ActivityLogBL.ActivityLogMapper(Modules.Task.ToString(), 10, task.Param_CompID, task.Param_UserID
, UserName, System.Reflection.MethodBase.GetCurrentMethod().Name, task.Param_TaskName, "", task.Param_ProjectName, task.Param_StatusName);
var dsActivityLog = ActivityLogBL.LogCRUD(objlog);
#endregion Activity Log
}
catch (Exception ex)
{
data = Utility.Exception(ex);;
}
}
else
{
data = Utility.AuthenticationError();
}
return(new APIResult(Request, data));
}
private static MySqlCommand mySqlCommandParameters(MySqlCommand cmd, UpdateTaskManagement task)
{
cmd.Parameters.AddWithValue("Param_ProjectID", task.Param_ProjectID);
cmd.Parameters.AddWithValue("Param_TaskID", task.Param_TaskID);
cmd.Parameters.AddWithValue("Param_CompID", task.Param_CompID);
cmd.Parameters.AddWithValue("Param_SubTaskIds", task.Param_SubTaskIds);
cmd.Parameters.AddWithValue("Param_StatusID", task.Param_StatusID);
cmd.Parameters.AddWithValue("Param_Comments", task.Param_Comments);
cmd.Parameters.AddWithValue("Param_UserID", task.Param_UserID);
return(cmd);
}
public static DataSet TaskUpdate(UpdateTaskManagement updateTaskManagement)
{
DataSet dsresult = new DataSet();
try
{
dsresult = TaskDAL.TaskUpdate(updateTaskManagement);
}
catch (Exception ex)
{
Log(ex, System.Reflection.MethodBase.GetCurrentMethod().Name);
throw ex;
}
return(dsresult);
}
