public Result <bool> insert_nhaxuatban(nhaxuatban_ett nhaxuatban)
{
Result <bool> rs = new Result <bool>();
try
{
// create new tbl_nhaxuatban to insert to database_context
tbl_nxb temp = new tbl_nxb();
temp.tennxb = nhaxuatban.tennxb;
temp.sdt = nhaxuatban.sdt;
temp.diachi = nhaxuatban.diachi;
db.tbl_nxbs.InsertOnSubmit(temp);
db.SubmitChanges();
rs.data = true;
rs.errcode = ErrorCode.sucess;
return(rs);
}
catch (Exception e)
{
rs.data = false;
rs.errcode = ErrorCode.fail;
rs.errInfor = e.ToString();
return(rs);
}
}
public Result <List <nhaxuatban_ett> > select_all_nhaxuatban()
{
Result <List <nhaxuatban_ett> > rs = new Result <List <nhaxuatban_ett> >();
try
{
List <nhaxuatban_ett> lst = new List <nhaxuatban_ett>();
var dt = db.tbl_nxbs;
if (dt.Count() > 0)
{
foreach (tbl_nxb item in dt)
{
nhaxuatban_ett temp = new nhaxuatban_ett(item);
lst.Add(temp);
}
rs.data = lst;
rs.errcode = ErrorCode.sucess;
}
else
{
rs.data = null;
rs.errInfor = Constants.empty_data;
}
return(rs);
}
catch (Exception e)
{
rs.data = null;
rs.errInfor = e.ToString();
rs.errcode = ErrorCode.fail;
return(rs);
}
}
public Result <bool> edit_nhaxuatban(nhaxuatban_ett nhaxuatban)
{
Result <bool> rs = new Result <bool>();
try
{
// find the only row to edit
var dt = db.tbl_nxbs.Where(o => o.manxb == nhaxuatban.manxb).SingleOrDefault();
// if fields are null or "" then maintaining the old data;
if (nhaxuatban.tennxb != null && nhaxuatban.tennxb != "")
{
dt.tennxb = nhaxuatban.tennxb;
}
if (nhaxuatban.sdt != null && nhaxuatban.sdt != "")
{
dt.sdt = nhaxuatban.sdt;
}
if (nhaxuatban.diachi != null && nhaxuatban.diachi != "")
{
dt.diachi = nhaxuatban.diachi;
}
db.SubmitChanges();
rs.data = true;
rs.errcode = ErrorCode.sucess;
return(rs);
}
catch (Exception e)
{
rs.data = false;
rs.errcode = ErrorCode.fail;
rs.errInfor = e.ToString();
return(rs);
}
}
public Result <List <nhaxuatban_ett> > select_nhaxuatban_fields(string input, string howtosearch)
{
Result <List <nhaxuatban_ett> > rs = new Result <List <nhaxuatban_ett> >();
try
{
IQueryable <tbl_nxb> dt = null;
List <nhaxuatban_ett> lst = new List <nhaxuatban_ett>();
switch (howtosearch)
{
case "tennxb":
dt = db.tbl_nxbs.Where(o => o.tennxb.Contains(input));
break;
default:
break;
}
if (dt.Count() > 0)
{
foreach (tbl_nxb item in dt)
{
nhaxuatban_ett temp = new nhaxuatban_ett(item);
lst.Add(temp);
}
rs.data = lst;
rs.errcode = ErrorCode.sucess;
return(rs);
}
else
{
rs.data = null;
rs.errInfor = Constants.empty_data;
return(rs);
}
}
catch (Exception e)
{
rs.data = null;
rs.errInfor = e.ToString();
rs.errcode = ErrorCode.fail;
return(rs);
}
}
