public WMUpdateViewModel update_reviewerdata(WorkMaint data)
{
WMUpdateViewModel retVal = new WMUpdateViewModel(FinTrackRes.WM_UPDATE_ERR, false);
SqlCommand cmd = null;
try
{
using (con = new SqlConnection(conStr))
{
con.Open();
using (cmd = new SqlCommand(StaticData.UPDATE_REVIEWER_WORKMAINTENANCE, con))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@workitemid", data.WorkItemId);
cmd.Parameters.AddWithValue("@userid", Common.GetUser.UserId);
cmd.Parameters.AddWithValue("@revcomments", data.ReviewerComments);
cmd.Parameters.AddWithValue("@starteddate", DateTime.Now);
cmd.Parameters.AddWithValue("@itemstatus", data.Status);
cmd.Parameters.AddWithValue("@usertype", "Reviewer"); //Hard coding this because this will be used only by the reviewer.
cmd.Parameters.AddWithValue("@iserrorfound", data.ErrFound);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.Read())
{
retVal.WMCnt = Convert.ToInt32(rdr["wmcnt"]);
retVal.RevieweeId = Convert.ToString(rdr["RevieweeId"]);
}
retVal._success = true;
if (data.Status == "Rework")//Rework then display the message.
{
retVal._message = FinTrackRes.WM_UPDATE_REW;
}
else
{
retVal._message = FinTrackRes.WM_UPDATE_APPR_ERR_FIND;
}
CloseReader(rdr);
}
}
}
catch (Exception ex)
{
Logger.Log(Logger.LogType.Error, ex.ToString());
}
return(retVal);
}
public WMUpdateViewModel update(WorkMaint data)
{
WMUpdateViewModel retVal = new WMUpdateViewModel(FinTrackRes.WM_UPDATE_ERR, false);
SqlCommand cmd = null;
try
{
using (con = new SqlConnection(conStr))
{
con.Open();
using (cmd = new SqlCommand(StaticData.UPDATE_WORKMAINTENANCE, con))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@workitemid", data.WorkItemId);
cmd.Parameters.AddWithValue("@userid", Common.GetUser.UserId);
cmd.Parameters.AddWithValue("@comments", data.Comments);
cmd.Parameters.AddWithValue("@starteddate", DateTime.Now);
cmd.Parameters.AddWithValue("@itemstatus", data.Status);
cmd.Parameters.AddWithValue("@usertype", "Processor");
cmd.Parameters.AddWithValue("@invoicenumber", data.InvoiceNumber);
cmd.Parameters.AddWithValue("@requestnumber", data.RequestNumber);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.Read())
{
retVal.WMCnt = Convert.ToInt32(rdr["revcnt"]);
}
retVal._success = true;
if (data.Status.Contains("Submitted"))
{
retVal._message = FinTrackRes.WM_UPDATE;
}
else
{
retVal._message = String.Empty;
}
CloseReader(rdr);
}
}
}
catch (Exception ex)
{
Logger.Log(Logger.LogType.Error, ex.ToString());
}
return(retVal);
}
