public int Update(Models.MRoles model) { Common.Logger l = new Common.Logger(); string ClassName = "CRoles"; try { var query = from o in obj.Roles where Convert.ToString(o.id) == model.id select o; foreach (var item in query) { item.id = int.Parse(model.id); item.RoleName = model.RoleName; } l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] RoleName[" + model.RoleName + "] "); obj.SubmitChanges(); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Updated Successfully"); return(1); } catch (Exception ex) { l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString()); return(-1); } }
public List <Models.MRoles> GetAll() { List <Models.MRoles> model = new List <Models.MRoles>(); var query = from o in obj.Roles select o; foreach (var item in query) { Models.MRoles m = new Models.MRoles(); m.id = Convert.ToString(item.id); m.RoleName = item.RoleName; model.Add(m); } return(model); }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { string RoleName = txtRoleName.Text; Models.MRoles mr = new Models.MRoles(); Classes.CRoles cr = new Classes.CRoles(); mr.RoleName = RoleName; if (cr.Save(mr) < 0) { ShowFailMessage(); } else { ShowSuccessMessage(); ClearTextBoxes(Page); } } }
public int Save(Models.MRoles model) { Common.Logger l = new Common.Logger(); string ClassName = "CRoles"; try { DB.Role bs = new DB.Role(); //bs.id = int.Parse(model.id); bs.RoleName = model.RoleName; l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] RoleName[" + model.RoleName + "] "); obj.Roles.InsertOnSubmit(bs); obj.SubmitChanges(); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Inserted Successfully"); return(1); } catch (Exception ex) { l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString()); return(-1); } }