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