public ActionResult JobOrderCancel_OnSubmit(int Id, string ReturnUrl)
{
string ConnectionString = (string)System.Web.HttpContext.Current.Session["DefaultConnectionString"];
JobOrderCancelHeader JobOrderCancelHeader = new JobOrderCancelHeaderService(_unitOfWork).Find(Id);
try
{
using (SqlConnection sqlConnection = new SqlConnection(ConnectionString))
{
sqlConnection.Open();
using (SqlCommand cmd = new SqlCommand("" + ConfigurationManager.AppSettings["DataBaseSchema"] + ".sp_PostBomForWeavingOrderCancel"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = sqlConnection;
cmd.Parameters.AddWithValue("@JobOrderCancelHeaderId", Id);
cmd.CommandTimeout = 1000;
cmd.ExecuteNonQuery();
}
using (SqlCommand cmd = new SqlCommand("" + ConfigurationManager.AppSettings["DataBaseSchema"] + ".sp_PostRequisitionCancelForWeavingOrderCancel"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = sqlConnection;
cmd.Parameters.AddWithValue("@JobOrderCancelHeaderId", Id);
cmd.CommandTimeout = 1000;
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
JobOrderCancelHeader.Status = (int)StatusConstants.Drafted;
new JobOrderCancelHeaderService(_unitOfWork).Update(JobOrderCancelHeader);
_unitOfWork.Save();
throw ex;
}
return(Redirect(ReturnUrl));
}
public ActionResult JobOrderCancel_OnApprove(int Id, string ReturnUrl)
{
JobOrderCancelHeader H = new JobOrderCancelHeaderService(_unitOfWork).Find(Id);
return(Redirect(ReturnUrl));
}
