public void update_item_company_code() ///UPDATE ITEM COMPANY CODE IN DATABASE { code temp = (from x in objentities.codes select x).FirstOrDefault(); temp.company_id = temp.company_id + 1; objentities.SaveChanges(); }
public ActionResult item_company(itemcompanymodel obj, string Add, string Delete) { if (ModelState.IsValid) { item_company oo = new item_company(); ////object of model oo.item_company_name = obj.item_company_name; using (ebmsEntities abj = new ebmsEntities()) ///object of entities { if (!string.IsNullOrEmpty(Add)) { string item_company_code = objcommon.read_item_company_code(); oo.item_company_id = item_company_code; oo.item_company_name = obj.item_company_name; abj.item_company.Add(oo); abj.SaveChanges(); objcommon.update_item_company_code(); } if (!string.IsNullOrEmpty(Delete)) { } } } return(View()); }
public ActionResult item_group(itemgroupmodel obj, string Add, string Delete) { if (ModelState.IsValid) { using (ebmsEntities abj = new ebmsEntities()) { if (!string.IsNullOrEmpty(Add)) { item_group oo = new item_group(); string item_group_code = objcommon.read_item_group_code(); oo.item_group_id = item_group_code; oo.item_group_name = obj.item_group_name; abj.item_group.Add(oo); abj.SaveChanges(); //// ADD ITEM COMPANY RECORD objcommon.update_item_group_code(); //// UPDATE ITEM COMPANY CODE ModelState.Clear(); } if (!string.IsNullOrEmpty(Delete)) { } } } return(View()); }
public ActionResult state(statelistmodel obj, string Add, string Delete) { if (ModelState.IsValid) { using (ebmsEntities abj = new ebmsEntities()) { state_list oo = new state_list(); oo.state_code = obj.state_code.ToString(); oo.state_name = obj.state_name.ToString(); string state_code = objcommon.read_state_code(); oo.state_id = state_code.ToString(); bool res = objcommon.check_state_exist(oo.state_code, oo.state_name); if (res == false) { abj.state_list.Add(oo); abj.SaveChanges(); objcommon.update_statelist_code(); ViewBag.message = "Record Saved Successfully!!!!!"; ModelState.Clear(); } else { ViewBag.message = "Duplicate Recod Found!!!!!"; } } } return(View()); }