public void save(InstrumentSerialMaster InstrumentSerialMaster, string userId, bool isNew) { try { using (var context = new SmsMisDB()) { var entrymain = context.Entry(InstrumentSerialMaster); if (entrymain != null) { InstrumentSerialMaster.AddDateTime = DateTime.Now; InstrumentSerialMaster.AddByUserId = userId; InstrumentSerialMaster.InstrumentSerialDetail = new List <InstrumentSerialDetail>(); for (int i = Convert.ToInt32(InstrumentSerialMaster.StartingInstrumentNo); i <= Convert.ToInt32(InstrumentSerialMaster.EndingInstrumentNo); i++) { InstrumentSerialDetail detail = new InstrumentSerialDetail(); detail.CompanyCode = InstrumentSerialMaster.CompanyCode; detail.BranchCode = InstrumentSerialMaster.BranchCode; detail.AccountCode = InstrumentSerialMaster.AccountCode; detail.Cancelled = false; detail.InstrumentTypeCode = InstrumentSerialMaster.InstrumentTypeCode; detail.InstrumentNo = i; InstrumentSerialMaster.InstrumentSerialDetail.Add(detail); } if (isNew) { //InstrumentSerialMaster.InstrumentTypeSerial = Functions.getNextPk("InstrumentSerialMaster", "InstrumentTypeSerial", string.Concat(" WHERE CompanyCode=", InstrumentSerialMaster.CompanyCode, " AND BranchCode=", InstrumentSerialMaster.BranchCode, " AND AccountCode='", InstrumentSerialMaster.AccountCode, "' AND InstrumentTypeCode=", InstrumentSerialMaster.InstrumentTypeCode)); entrymain.State = EntityState.Added; } else { if (InstrumentSerialMaster.InstrumentSerialDetail != null && InstrumentSerialMaster.InstrumentSerialDetail.Count > 0) { InstrumentSerialMaster.InstrumentSerialDetail.ToList().ForEach(i => { i.CompanyCode = InstrumentSerialMaster.CompanyCode; }); InstrumentSerialMaster.InstrumentSerialDetail.ToList().ForEach(i => { i.BranchCode = InstrumentSerialMaster.BranchCode; }); InstrumentSerialMaster.InstrumentSerialDetail.ToList().ForEach(i => { i.AccountCode = InstrumentSerialMaster.AccountCode; }); InstrumentSerialMaster.InstrumentSerialDetail.ToList().ForEach(i => { i.InstrumentTypeCode = InstrumentSerialMaster.InstrumentTypeCode; }); } entrymain.State = EntityState.Modified; } if (InstrumentSerialMaster.InstrumentSerialDetail != null && InstrumentSerialMaster.InstrumentSerialDetail.Count > 0) { InstrumentSerialMaster.InstrumentSerialDetail.ToList <InstrumentSerialDetail>().ForEach(entry => context.Entry(entry).State = EntityState.Added); } context.InstrumentSerialDetail.ToList().Where(i => i.BranchCode == InstrumentSerialMaster.BranchCode && i.CompanyCode == InstrumentSerialMaster.CompanyCode && i.AccountCode == InstrumentSerialMaster.AccountCode && i.InstrumentTypeCode == InstrumentSerialMaster.InstrumentTypeCode).ToList <InstrumentSerialDetail>().ForEach(entry => context.Entry(entry).State = EntityState.Deleted); context.SaveChanges(); } } } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { //throw ex; } catch (Exception ex) { // throw ex; } }
public JsonResult saveInstrumentCancelled(InstrumentSerialDetail InstrumentSerialDetail) { try { new hdlInstrumentSerialMaster().save(InstrumentSerialDetail, Convert.ToString(Session["User"])); } catch (Exception ex) { Response.StatusCode = 500; Content(JsonConvert.SerializeObject(new { error = ex.Message })); } return(Json("", JsonRequestBehavior.AllowGet)); //return getAllInstrumentSerialMaster(); }