public ActionResult JobReturn_OnSubmit(int Id, string ReturnUrl) { int Cnt = 0; JobReturnHeader Header = new JobReturnHeaderService(_unitOfWork).Find(Id); string ConnectionString = (string)System.Web.HttpContext.Current.Session["DefaultConnectionString"]; try { DataSet ds = new DataSet(); using (SqlConnection sqlConnection = new SqlConnection(ConnectionString)) { sqlConnection.Open(); using (SqlCommand cmd = new SqlCommand("" + ConfigurationManager.AppSettings["DataBaseSchema"] + ".sp_PostBomForWeavingReturn")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = sqlConnection; cmd.Parameters.AddWithValue("@JobReturnHeaderId", Id); cmd.CommandTimeout = 1000; //cmd.Connection.Open(); cmd.ExecuteNonQuery(); //cmd.Connection.Close(); } using (SqlCommand cmd = new SqlCommand("" + ConfigurationManager.AppSettings["DataBaseSchema"] + ".sp_PostWeavingReturnAtBranch")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = sqlConnection; cmd.Parameters.AddWithValue("@JobReturnHeaderId", Id); cmd.CommandTimeout = 1000; //cmd.Connection.Open(); cmd.ExecuteNonQuery(); //cmd.Connection.Close(); } var Temp = (from L in db.JobReturnLine where L.JobReturnHeaderId == Id select new { JobReceiveHeaderId = L.JobReceiveLine.JobReceiveHeaderId }).Distinct(); foreach (var item in Temp) { using (SqlCommand cmd = new SqlCommand("" + ConfigurationManager.AppSettings["DataBaseSchema"] + ".Mig_WeavingReceiveLedgerPosting")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = sqlConnection; cmd.Parameters.AddWithValue("@JobReceiveHeaderId", item.JobReceiveHeaderId); cmd.CommandTimeout = 1000; cmd.ExecuteNonQuery(); } //using (SqlCommand cmd = new SqlCommand("" + ConfigurationManager.AppSettings["DataBaseSchema"] + ".Mig_PostWeavingConsumption_OldData")) //{ // cmd.CommandType = CommandType.StoredProcedure; // cmd.Connection = sqlConnection; // cmd.Parameters.AddWithValue("@JobReceiveHeaderId", item.JobReceiveHeaderId); // cmd.CommandTimeout = 1000; // cmd.ExecuteNonQuery(); //} } //var TempBranch = (from L in db.JobReturnLine // join BJrl in db.JobReceiveLine on L.JobReceiveLineId equals BJrl.JobReceiveLineId into JobReceiveLineTable // from JobReceiveLineTab in JobReceiveLineTable.DefaultIfEmpty() // where L.JobReturnHeaderId == Id // select new // { // JobReceiveHeaderId = JobReceiveLineTab.JobReceiveHeaderId // }).Distinct(); //foreach (var item in TempBranch) //{ // using (SqlCommand cmd = new SqlCommand("" + ConfigurationManager.AppSettings["DataBaseSchema"] + ".Mig_PostWeavingConsumption_OldData")) // { // cmd.CommandType = CommandType.StoredProcedure; // cmd.Connection = sqlConnection; // cmd.Parameters.AddWithValue("@JobReceiveHeaderId", item.JobReceiveHeaderId); // cmd.CommandTimeout = 1000; // cmd.ExecuteNonQuery(); // } //} } } catch (Exception ex) { Header.Status = (int)StatusConstants.Drafted; new JobReturnHeaderService(_unitOfWork).Update(Header); _unitOfWork.Save(); throw ex; } return(Redirect(ReturnUrl)); }
public ActionResult JobReturn_OnApprove(int Id, string ReturnUrl) { JobReturnHeader H = new JobReturnHeaderService(_unitOfWork).Find(Id); return(Redirect(ReturnUrl)); }