public async Task <bool> UpdateData(string id, Ordersampletbl obj) { try { if (id != obj.NoBalittanah) { return(false); } using (var context = new smlpobDB()) { context.Ordersampletbl.Attach(obj); context.Entry(obj).Property(x => x.OrderNo).IsModified = true; context.Entry(obj).Property(x => x.SampleCode).IsModified = true; context.Entry(obj).Property(x => x.CountNumber).IsModified = true; context.Entry(obj).Property(x => x.SampleDescription).IsModified = true; context.Entry(obj).Property(x => x.SamplingDate).IsModified = true; context.Entry(obj).Property(x => x.Village).IsModified = true; context.Entry(obj).Property(x => x.SubDistrict).IsModified = true; context.Entry(obj).Property(x => x.District).IsModified = true; context.Entry(obj).Property(x => x.Province).IsModified = true; context.Entry(obj).Property(x => x.Longitude).IsModified = true; context.Entry(obj).Property(x => x.Latitude).IsModified = true; context.Entry(obj).Property(x => x.LandUse).IsModified = true; context.Entry(obj).Property(x => x.IsReceived).IsModified = true; context.Entry(obj).Property(x => x.ModBy).IsModified = true; context.Entry(obj).Property(x => x.ModDate).IsModified = true; await context.SaveChangesAsync(); return(true); } } catch (Exception ex) { LogHelpers.source = this.GetType().Name; LogHelpers.message = ex.Message; LogHelpers.user = ""; LogHelpers.WriteLog(); } return(false); }
public async Task <bool> AddData(Ordersampletbl obj) { try { using (var context = new smlpobDB()) { context.Ordersampletbl.Add(obj); await context.SaveChangesAsync(); return(true); } } catch (Exception ex) { LogHelpers.source = this.GetType().Name; LogHelpers.message = ex.Message; LogHelpers.user = ""; LogHelpers.WriteLog(); } return(false); }
public string AutoGenerateSample(string komoditas, string analisis) { try { int no = int.Parse(komoditas); string cmdt = ""; using (var context = new smlpobDB()) { var kmd = (from x in context.Comoditytbl where x.ComodityNo == no select x.ComodityName).AsNoTracking().SingleOrDefault(); cmdt = kmd; } string id = ""; string kodeKomoditas = ""; string kodeAnalisis = ""; // kode komoditas if (cmdt.Contains("Pupuk Organik")) { kodeKomoditas = "Po."; } else if (cmdt.Contains("Pupuk Anorganik")) { kodeKomoditas = "Pa."; } else if (cmdt.Contains("Tanah")) { kodeKomoditas = "Th."; } else if (cmdt.Contains("Air")) { kodeKomoditas = "A."; } else if (cmdt.Contains("Tanaman")) { kodeKomoditas = "Tn."; } // kode analisis if (analisis.Contains("Kimia")) { kodeAnalisis = "K."; } else if (analisis.Contains("Biologi")) { kodeAnalisis = "B."; } else if (analisis.Contains("Fisika")) { kodeAnalisis = "F."; } using (var context = new smlpobDB()) { var data = (from x in context.Ordersampletbl .OrderByDescending(x => x.NoBalittanah) where x.NoBalittanah.Contains(kodeKomoditas) && x.NoBalittanah.Contains(kodeAnalisis) select x.NoBalittanah).AsNoTracking().SingleOrDefault(); if (data != null) { string[] strSplit = data.Split('.'); int noUrut1 = int.Parse(strSplit[2]); int noUrut2 = int.Parse(strSplit[5]); string newNoUrut1 = (noUrut1 + 1).ToString(); string newNoUrut2 = (noUrut2 + 1).ToString(); id = DatetimeHelper.GetYearNow() + "." + DatetimeHelper.GetMonthNow() + "." + newNoUrut1 + "." + kodeAnalisis + kodeKomoditas + newNoUrut2; } else { id = DatetimeHelper.GetYearNow() + "." + DatetimeHelper.GetMonthNow() + "." + "1" + "." + kodeAnalisis + kodeKomoditas + "1"; } var sample = new Ordersampletbl { NoBalittanah = id, SampleCode = "", }; context.Ordersampletbl.Add(sample); context.SaveChangesAsync(); return(id); } } catch (Exception ex) { LogHelpers.source = this.GetType().Name; LogHelpers.message = ex.Message; LogHelpers.user = currentUser; LogHelpers.WriteLog(); } return(null); }