public int AddFlats(int TotalFloor, int FlatOrder, List <int> FlatNo, List <bool> PreIncrement, List <PLCModel> pmodel, string username, int towerID, string FltType, string FltTSize) { PLCService pservice = new PLCService(); int plcCount = pservice.GetPLCCount(); using (REMSDBEntities context = new REMSDBEntities()) { try { for (int i = 1; i <= TotalFloor; i++) { int kk = 0; Floor flo = new Floor(); flo.CrBy = username; flo.CrDate = DateTime.Now; flo.TowerID = towerID; flo.FloorName = i.ToString(); flo.FloorNo = i; context.Floors.Add(flo); context.SaveChanges(); int jj = 0; foreach (int flat in FlatNo) { int fno = GenFlatNo(i, flat, PreIncrement[jj]); Flat fl = new Flat(); fl.FlatOrder = FlatOrder; fl.FlatNo = fno.ToString(); fl.FlatName = fno.ToString(); fl.FloorID = flo.FloorID; fl.FlatType = FltType; fl.FlatSizeUnit = "SqFt"; fl.FlatSize = Convert.ToDecimal(FltTSize); fl.Status = "Available"; context.Flats.Add(fl); context.SaveChanges(); for (int k = 0; k <= plcCount - 1; k++) { var pl = pmodel[kk]; if (pl.PLCID != 0) { FlatPLC fpcl = new FlatPLC(); fpcl.CrDate = DateTime.Now; fpcl.FlatID = fl.FlatID; fpcl.PLCID = pl.PLCID; context.FlatPLCs.Add(fpcl); context.SaveChanges(); } kk++; } jj++; } } return(1); } catch (Exception ex) { return(0); } } }
public string UpdateFlat(FlatModel flat) { Mapper.CreateMap <FlatModel, Flat>().ForMember(dest => dest.FlatPLCs, sec => sec.Ignore()); Flat fl = Mapper.Map <FlatModel, Flat>(flat); int i = fservice.EditFlat(fl); FlatPLCService fpservice = new FlatPLCService(); var model = fpservice.GetFlatPLCListByFlatID(fl.FlatID); foreach (var ft in model) { FlatPLC md = new FlatPLC(); md.FlatPLCID = ft.FlatPLCID; int ii = fpservice.DeleteFlatPLC(md); } foreach (string st in flat.FlatPLCs) { if (st != "0") { FlatPLC fpm = new FlatPLC(); fpm.FlatID = fl.FlatID; fpm.PLCID = Convert.ToInt32(st); int ii = fpservice.AddFlatPLC(fpm); } } return(i.ToString()); }
public int AddFlatPLC(FlatPLC model) { using (REMSDBEntities context = new REMSDBEntities()) { try { context.FlatPLCs.Add(model); int i = context.SaveChanges(); return(i); } catch (Exception ex) { Helper hp = new Helper(); hp.LogException(ex); return(0); } } }
public int EditFlatPLC(FlatPLC model) { using (REMSDBEntities context = new REMSDBEntities()) { try { context.FlatPLCs.Add(model); context.Entry(model).State = EntityState.Modified; int i = context.SaveChanges(); return(i); } catch (Exception ex) { Helper hp = new Helper(); hp.LogException(ex); return(0); } } }
public int DeleteFlat(int flatid) { using (REMSDBEntities context = new REMSDBEntities()) { try { FlatPLCService fpservice = new FlatPLCService(); FlatChargeService fcservice = new FlatChargeService(); var model = fpservice.GetFlatPLCListByFlatID(flatid); foreach (var md in model) { FlatPLC plc = new FlatPLC(); plc.FlatPLCID = md.FlatPLCID; context.FlatPLCs.Add(plc); context.Entry(plc).State = EntityState.Deleted; context.SaveChanges(); } var fmodel = fcservice.GetFlatChargeListByFlatID(flatid); foreach (var md in fmodel) { FlatCharge plc = new FlatCharge(); plc.FlatChargeID = md.FlatChargeID; context.FlatCharges.Add(plc); context.Entry(plc).State = EntityState.Deleted; context.SaveChanges(); } Flat ft = new Flat(); ft.FlatID = flatid; context.Flats.Add(ft); context.Entry(ft).State = EntityState.Deleted; int i = context.SaveChanges(); return(i); } catch (Exception ex) { Helper hp = new Helper(); hp.LogException(ex); return(0); } } }
public string SaveFat(FlatModel flat) { Mapper.CreateMap <FlatModel, Flat>().ForMember(dsd => dsd.FlatPLCs, df => df.Ignore()); Flat fl = Mapper.Map <FlatModel, Flat>(flat); fl.CrBy = User.Identity.Name; fl.CrDate = DateTime.Now; int i = fservice.AddNewFlat(fl); FlatPLCService fpservice = new FlatPLCService(); foreach (string st in flat.FlatPLCs) { if (st != "0") { FlatPLC fpm = new FlatPLC(); fpm.FlatID = fl.FlatID; fpm.PLCID = Convert.ToInt32(st); int ii = fpservice.AddFlatPLC(fpm); } } return(i.ToString()); }
public bool IsPLCinFlat(int plcid, int flatid) { using (REMSDBEntities context = new REMSDBEntities()) { try { FlatPLC model = context.FlatPLCs.Where(pl => pl.PLCID == plcid && pl.FlatID == flatid).FirstOrDefault(); if (model.FlatID == null) { return(false); } else { return(true); } } catch (Exception ex) { Helper hp = new Helper(); hp.LogException(ex); return(false); } } }