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());
}
