private void AddUnit() { int C = 0; if (Check_Save()) { return; } try { dgvData.EndEdit(); using (DataClasses1DataContext db = new DataClasses1DataContext()) { foreach (var g in dgvData.Rows) { if (g.IsVisible.Equals(false)) { var dd = (from ix in db.tb_Locations where ix.id == Convert.ToInt16(g.Cells["id"].Value) select ix).ToList(); if (dd.Count > 0) { dbClss.AddHistory(this.Name, "ลบ", "ลบสถานที่เก็บ [" + dd.FirstOrDefault().Location + "]", ""); db.tb_Locations.DeleteAllOnSubmit(dd); db.SubmitChanges(); C += 1; } } } foreach (var g in dgvData.Rows) { if (g.IsVisible) { if (Convert.ToBoolean(g.Cells["dgvC"].Value)) { if (Convert.ToInt16(g.Cells["id"].Value) <= 0) { var a = (from ix in db.tb_Locations where ix.Location.ToUpper() == Convert.ToString(g.Cells["Location"].Value).Trim().ToUpper() select ix).ToList(); if (a.Count() <= 0) { tb_Location gy = new tb_Location(); gy.Location = Convert.ToString(g.Cells["Location"].Value).Trim(); gy.CreateDate = DateTime.Now; gy.CreateBy = ClassLib.Classlib.User; gy.Active = Convert.ToBoolean(g.Cells["Active"].Value); gy.Status = "Completed"; db.tb_Locations.InsertOnSubmit(gy); db.SubmitChanges(); dbClss.AddHistory(this.Name, "เพิ่มสถานที่เก็บ", "เพิ่มสถานที่เก็บ [" + gy.Location + " Status : " + gy.Active.ToString() + "]", ""); C += 1; } } else { var a = (from ix in db.tb_Locations where ix.id == Convert.ToInt16(g.Cells["id"].Value) select ix).ToList(); if (a.Count > 0) { var unit1 = (from ix in db.tb_Locations where ix.id == Convert.ToInt16(g.Cells["id"].Value) select ix).First(); unit1.Location = Convert.ToString(g.Cells["Location"].Value).Trim(); unit1.Active = Convert.ToBoolean(g.Cells["Active"].Value); unit1.CreateDate = DateTime.Now; unit1.CreateBy = ClassLib.Classlib.User; C += 1; db.SubmitChanges(); dbClss.AddHistory(this.Name, "แก้ไข", "แก้ไขสถานที่เก็บ [" + unit1.Location + " Status : " + unit1.Active.ToString() + "]", ""); } } } } //else //Delete //{ // var dd = (from ix in db.tb_Departments // where ix.id == Convert.ToInt16(g.Cells["id"].Value) // select ix).ToList(); // if (dd.Count > 0) // { // dbClss.AddHistory(this.Name, "ลบ", "ลบแผนก [" + dd.FirstOrDefault().Department + "]", ""); // db.tb_Departments.DeleteAllOnSubmit(dd); // db.SubmitChanges(); // } //} } } } catch (Exception ex) { MessageBox.Show(ex.Message); dbClss.AddError(this.Name, ex.Message, this.Name); } if (C > 0) { MessageBox.Show("บันทึกสำเร็จ!"); DataLoad(); ViewClick(); } }
public IHttpActionResult AddNewLocation([FromBody] AddNewLocationModel model) { AmigoWallEntities db = new AmigoWallEntities(); var location = new tb_Location { Id = Guid.NewGuid().ToString(), AddTime = UtilityHelper.getNow(), Latitude = model.latitude, longitude = model.longtitude, LocationName = model.LocationName, FullAddress = model.AddressName, Status = 0, UserId = db.AspNetUsers.Single(u => u.UserName == User.Identity.Name).Id }; db.tb_Location.Add(location); db.SaveChanges(); return Json(new { Code = 10000, Detail = new { } }); }