public Boolean SaveLog(Order_OI_STI_Header record) { try { var log = new Order_OI_STI_Header_Log { OrderNumber = record.OrderNumber, FacilityCode = record.FacilityCode, OrderStatusId = System.Convert.ToInt32(record.OrderStatusId), OrderStatusChangedBy = new UserManagement().getCurrentuser(), OrderStatusDateChanged = DateTime.Now, StartDate = record.StartDate, EndDate = record.EndDate, DatePrepared = record.DatePrepared, OrderTypeId = record.OrderTypeId, ProductCategoryId = 9 }; context.Order_OI_STI_Header_Log.Add(log); context.SaveChanges(); return(true); } catch (Exception e) { throw (e); } }
//public ActionResult DialogInsertHSIP(Order_OI_STI_Header value) //{ // string OrderNumber = new OrderNumber().GetOrderNumber(System.Convert.ToDateTime(value.DatePrepared), value.FacilityCode, "09", "02"); // OrderOISTIHeaderModels obj = new OrderOISTIHeaderModels(); // obj.OrderNumber = OrderNumber; // TempData["OrderNumber"] = OrderNumber; // obj.DatePrepared = System.Convert.ToDateTime(value.DatePrepared); // obj.FacilityCode = value.FacilityCode; // obj.StartDate = value.StartDate; // obj.EndDate = value.EndDate; // obj.OrderTypeId = 2; // obj.OrderStatusId = 1; // obj.FinalSubmission = System.Convert.ToBoolean(value.FinalSubmission); // obj.EditedBy = new UserManagement().getCurrentuser(); // obj.EditedDate = DateTime.Now; // obj.Save(); // return Json(value, JsonRequestBehavior.AllowGet); //} public ActionResult DialogInsertHSIPCustom(Order_OI_STI_Header value) { // EmailJob obx = new EmailJob(); context.Configuration.ProxyCreationEnabled = false; mascisEntities db_hv = new mascisEntities(); OrderOISTIHeaderModels obj = new OrderOISTIHeaderModels(); string OrderNumber = new OrderNumber().GetOrderNumber(System.Convert.ToDateTime(value.DatePrepared), value.FacilityCode, "09", "02"); db_hv.Order_OI_STI_Header.Add(value); value.OrderNumber = OrderNumber; TempData["OrderNumber"] = OrderNumber; value.OrderTypeId = 1; value.OrderStatusId = 1; value.StartDate = DateTime.Now; value.EndDate = DateTime.Now; value.EditedDate = DateTime.Now; value.EditedBy = new UserManagement().getCurrentuser(); db_hv.SaveChanges(); //obj.SaveLog(value); //obx.SendEmail(value.FacilityCode, value.OrderNumber); //if (value.FinalSubmission == true ) //{ // obx.SendEmail(value.FacilityCode, value.OrderNumber); //} return(Json(value, JsonRequestBehavior.AllowGet)); }
public ActionResult DialogUpdateHSIP(Order_OI_STI_Header value) { EmailJob email = new EmailJob(); context.Configuration.ProxyCreationEnabled = false; mascisEntities db_master = new mascisEntities(); Order_OI_STI_Header table = db_master.Order_OI_STI_Header.FirstOrDefault(o => o.OrderNumber == value.OrderNumber); TempData["OrderNumber"] = value.OrderNumber; value.OrderTypeId = 2; value.OrderStatusId = 1; value.EditedDate = DateTime.Now; value.EditedBy = new UserManagement().getCurrentuser(); db_master.Entry(table).CurrentValues.SetValues(value); db_master.Entry(table).State = EntityState.Modified; db_master.SaveChanges(); if (value.FinalSubmission == true && value.RFSO_SentBackTofacility == false) { email.OrderSentToScto(value.FacilityCode, value.OrderNumber, "OISTI"); } if (value.FinalSubmission == true && value.RFSO_SentBackTofacility == true) { email.OrderReSentToScto(value.FacilityCode, value.OrderNumber, "OISTI"); } return(Json(value, JsonRequestBehavior.AllowGet)); }
public Boolean Save() { try { if (GetRecordByKey(mOrderNumber) == null) { var x = new Order_OI_STI_Header { OrderNumber = mOrderNumber, FacilityCode = mFacilityCode, StartDate = mStartDate, EndDate = mEndDate, DatePrepared = mDatePrepared, EditedBy = new UserManagement().getCurrentuser(), EditedDate = DateTime.Now, // EmergencyOrder = mEmergencyOrder, FinalSubmission = mFinalSubmission, OrderTypeId = mOrderTypeId, OrderStatusId = mOrderStatusId, OrderStatusIdChangedBy = mOrderStatusIdChangedBy, OrderStatusIdDateChanged = mOrderStatusIdDateChanged, RFSO_SentBackTofacility = mRFSO_SentBackTofacility }; context.Order_OI_STI_Header.Add(x); context.SaveChanges(); ////SaveLog(x); return(true); } else { return(false); } } catch (Exception x) { throw (x); } }
public Boolean SaveOIs(string OrderNo) { try { var allocated = context.Order_OI_STI_Detail.Where(o => o.OrderNumber == OrderNo && o.Quantity_Allocated > 0).ToList().Count; if (allocated > 0) { if (GetRecordByKeyOIs(OrderNo) != null) { Order_OI_STI_Header t = new Order_OI_STI_Header(); t = GetRecordByKeyOIs(OrderNo); //DateTime eDate = t.EndDate; DateTime pDate = System.Convert.ToDateTime(t.DatePrepared); int facility = t.FacilityCode; var sapcode = context.A_Facilities.FirstOrDefault(a => a.FacilityCode == facility).SAP_Code; var x = new SAP_ExportHeader { OrderNumber = t.OrderNumber, AddedDate = System.DateTime.Now, AddedBy = new UserManagement().getCurrentuser(), CurrentReccord = true, RecordReadBySAP = false, DocNum = System.Convert.ToString(System.Convert.ToDateTime(pDate).Day + "" + System.Convert.ToDateTime(pDate).Month + "" + System.Convert.ToDateTime(pDate).Year + "" + facility), DocDate = System.Convert.ToDateTime(pDate), DocDueDate = System.Convert.ToDateTime(pDate), CardCode = sapcode,// t.A_Facilities.SAP_Code, DocEntry = mDocEntry, ProductCategory = 9, }; var order = context.SAP_ExportHeader.FirstOrDefault(o => o.OrderNumber == OrderNo); if (order == null) { context.SAP_ExportHeader.Add(x); context.SaveChanges(); } SAPExportDetails details = new SAPExportDetails(); details.SaveOIs(OrderNo); //var update = t; //update.OrderStatusId = 4; //context.Entry(t).CurrentValues.SetValues(update); //context.Entry(t).State = EntityState.Modified; //context.SaveChanges(); //context.SAP_ExportHeader.Add(x); //context.SaveChanges(); //SAPExportDetails details = new SAPExportDetails(); //details.SaveOIs(OrderNo); // to update the order status of the record //OrderOISTIHeaderModels sap = new OrderOISTIHeaderModels(); //sap.UpdateSAP(OrderNo); return(true); } else { // existing_records = true; return(false); } } else { // existing_records = true; return(false); } } catch (Exception x) { throw (x); } }