public static int Save_Mastervalues(int dataid, int tableid, int orgid, string value)
{
using (ComplaintsDataContext db = new ComplaintsDataContext())
{
tbl_lkp_data obj_tbl_lkp_data;
if (dataid == 0)
{
obj_tbl_lkp_data = new tbl_lkp_data();
}
else
{
obj_tbl_lkp_data = db.tbl_lkp_datas.Where(c => c.Lkp_data_ID == dataid).SingleOrDefault();
}
obj_tbl_lkp_data.Lkp_tbl_ID = tableid;
obj_tbl_lkp_data.Org_ID = orgid;
obj_tbl_lkp_data.Values = value;
if (dataid == 0)
{
db.tbl_lkp_datas.InsertOnSubmit(obj_tbl_lkp_data);
}
db.SubmitChanges();
return(obj_tbl_lkp_data.Lkp_data_ID);
}
}
public static void Delete_Mastervalues(int dataid)
{
using (ComplaintsDataContext db = new ComplaintsDataContext())
{
tbl_lkp_data obj = db.tbl_lkp_datas.Where(c => c.Lkp_data_ID == dataid).SingleOrDefault();
db.tbl_lkp_datas.DeleteOnSubmit(obj);
db.SubmitChanges();
}
}
