public Result<List<Khoa_ett>> select_by_paging_khoa(int current_page)
{
Result<List<Khoa_ett>> rs = new Result<List<Khoa_ett>>();
try
{
List<Khoa_ett> lst = new List<Khoa_ett>();
//check whether curren_page is out of range or not
if (current_page <= 0)
{
current_page = 1;
}
if (current_page > page_total_khoa)
{
current_page = page_total_khoa;
}
// index of beginning record
int num_skip_record = Constants.num_record_on_page * (current_page - 1);
// get all the record correspondly
var dt = db.tbl_khoas.Skip(num_skip_record).Take(Constants.num_record_on_page);
if (dt.Count() > 0)
{
foreach (tbl_khoa item in dt)
{
Khoa_ett temp = new Khoa_ett(item);
lst.Add(temp);
}
rs.data = lst;
rs.errorCode = ErrorCode.Sucess;
}
else
{
rs.data = null;
rs.errorInfor = Constants.empty_data;
}
}
catch (Exception e)
{
rs.data = null;
rs.errorCode = ErrorCode.False;
rs.errorInfor = e.ToString();
}
return rs;
}
// handle manipulations
public Result<List<Khoa_ett>> select_all_khoa()
{
Result<List<Khoa_ett>> rs = new Result<List<Khoa_ett>>();
try
{
List<Khoa_ett> lst = new List<Khoa_ett>();
// remember : linq select all table "tbl_khoa"
var dt = db.tbl_khoas;
if (dt.Count() > 0)
{
foreach (tbl_khoa item in dt)
{
Khoa_ett temp = new Khoa_ett(item);
lst.Add(temp);
}
rs.data = lst;
rs.errorCode = ErrorCode.Sucess;
}
else
{
rs.data = null;
rs.errorCode = ErrorCode.NaN;
rs.errorInfor = Constants.empty_data;
}
return rs;
}
catch (Exception ex)
{
rs.data = null;
rs.errorInfor = ex.ToString();
rs.errorCode = ErrorCode.False;
return rs;
}
}
public Result<List<Khoa_ett>> select_by_fields(string nameInput, string how_to_search)
{
Result<List<Khoa_ett>> rs = new Result<List<Khoa_ett>>();
try
{
IQueryable<tbl_khoa> dt = null;
List<Khoa_ett> lst = new List<Khoa_ett>();
switch (how_to_search)
{
case "makhoa":
dt = db.tbl_khoas.Where(o => o.makhoa.Contains(nameInput));
break;
case "tenkhoa":
dt = db.tbl_khoas.Where(o => o.tenkhoa.Contains(nameInput));
break;
case "diachi":
dt = db.tbl_khoas.Where(o => o.diachi.Contains(nameInput));
break;
case "dienthoai":
dt = db.tbl_khoas.Where(o => o.dienthoai.Contains(nameInput));
break;
default:
break;
}
if (dt.Count() > 0)
{
foreach (tbl_khoa item in dt)
{
Khoa_ett temp = new Khoa_ett(item);
lst.Add(temp);
}
rs.errorCode = ErrorCode.Sucess;
rs.data = lst;
}
else
{
rs.errorCode = ErrorCode.NaN;
rs.data = null;
}
return rs;
}
catch (Exception e)
{
rs.data = null;
rs.errorCode = ErrorCode.False;
rs.errorInfor = e.ToString();
return rs;
}
}
public Result<bool> insert_khoa(Khoa_ett khoa)
{
Result<bool> rs = new Result<bool>();
try
{
// create new tbl_khoa to insert to datacontext
tbl_khoa temp = new tbl_khoa();
temp.makhoa = khoa.makhoa;
temp.tenkhoa = khoa.tenkhoa;
temp.diachi = khoa.diachi;
temp.dienthoai = khoa.dienthoai;
// remember : linq insert data
db.tbl_khoas.InsertOnSubmit(temp);
// remember : all manipulations such as insert, update, delete have to use this command
db.SubmitChanges();
rs.data = true;
rs.errorCode = ErrorCode.Sucess;
return rs;
}
catch (Exception e)
{
rs.data = false;
rs.errorCode = ErrorCode.False;
rs.errorInfor = e.ToString();
return rs;
}
}