public static bool Add_NhaCc(NhaCungCap obj)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
entities.NhaCungCap.Add(obj);
entities.SaveChanges();
return(true);
}
}
public static bool Delete_BaoHanh(string id)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
entities.Bao_Hanh.Remove(entities.Bao_Hanh.Where(p => p.id_BaoHanh == id).FirstOrDefault());
entities.SaveChanges();
return(true);
}
}
public static bool Add_HangSX(Hang_SX obj)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
entities.Hang_SX.Add(obj);
entities.SaveChanges();
return(true);
}
}
//public static Bao_Hanh Get_IdWithName(string value)
//{
// string[] arr = value.Split('-');
// int km = int.Parse(arr[0]);
// int time = int.Parse(arr[1]);
// using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
// {
// return entities.Bao_Hanh.Where(prop => prop.km_BaoHanh == km && prop.time_BaoHanh == time).FirstOrDefault();
// }
//}
public static bool Add_BaoHanh(Bao_Hanh obj)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
entities.Bao_Hanh.Add(obj);
entities.SaveChanges();
return(true);
}
}
public static bool Delete_NhaCc(string id)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
entities.NhaCungCap.Remove(entities.NhaCungCap.Where(p => p.id_NhaCC == id).FirstOrDefault());
entities.SaveChanges();
return(true);
}
}
public static bool Delete_LoaiTK(string id)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
entities.Loai_TK.Remove(entities.Loai_TK.Where(p => p.id_LoaiTK == id).FirstOrDefault());
entities.SaveChanges();
return(true);
}
}
public static bool Add_LoaiTK(Loai_TK obj)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
entities.Loai_TK.Add(obj);
entities.SaveChanges();
return(true);
}
}
public static bool Add_DanhMuc(DanhMuc obj)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
entities.DanhMuc.Add(obj);
entities.SaveChanges();
}
return(true);
}
public static bool Update_TaiKhoanPass(string userName, string pass)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
TaiKhoan taiKhoan = entities.TaiKhoan.Where(p => p.user_Acc == userName).FirstOrDefault();
taiKhoan.pass_Acc = pass;
entities.SaveChanges();
return(true);
}
}
public static bool Delete_TaiKhoan(string value)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
entities.TaiKhoan.Remove(entities.TaiKhoan.Where(p => p.user_Acc == value).FirstOrDefault());
entities.TT_TaiKhoan.Remove(entities.TT_TaiKhoan.Where(p => p.user_Acc == value).FirstOrDefault());
entities.SaveChanges();
return(true);
}
}
public static bool Add_TaiKhoan(TaiKhoan taiKhoan, TT_TaiKhoan tT_TaiKhoan)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
entities.TaiKhoan.Add(taiKhoan);
entities.TT_TaiKhoan.Add(tT_TaiKhoan);
entities.SaveChanges();
return(true);
}
}
public static bool Edit_BaoHanh(Bao_Hanh obj)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
Bao_Hanh baoHanh = entities.Bao_Hanh.Find(obj.id_BaoHanh);
baoHanh.lim_BaoHanh = obj.lim_BaoHanh;
baoHanh.descript = obj.descript;
entities.SaveChanges();
return(true);
}
}
public static bool Edit_LoaiTK(Loai_TK obj)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
Loai_TK hang_SX = entities.Loai_TK.Find(obj.id_LoaiTK);
hang_SX.name_LoaiTK = obj.name_LoaiTK;
hang_SX.descrip_LoaiTK = obj.descrip_LoaiTK;
entities.SaveChanges();
return(true);
}
}
public static bool Edit_HangSX(Hang_SX obj)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
Hang_SX hang_SX = entities.Hang_SX.Find(obj.id_HangSX);
hang_SX.name_HangSX = obj.name_HangSX;
hang_SX.descrip_HangSX = obj.descrip_HangSX;
entities.SaveChanges();
return(true);
}
}
public static bool Edit_LoaiSp(Loai_SP obj)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
Loai_SP hang_SX = entities.Loai_SP.Find(obj.id_LoaiSP);
hang_SX.name_LoaiSP = obj.name_LoaiSP;
hang_SX.descrip_LoaiSP = obj.descrip_LoaiSP;
entities.SaveChanges();
return(true);
}
}
public static bool Edit_NhaCc(NhaCungCap obj)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
NhaCungCap nha_CC = entities.NhaCungCap.Find(obj.id_NhaCC);
nha_CC.name_NhaCC = obj.name_NhaCC;
nha_CC.phone_NhaCC = obj.phone_NhaCC;
nha_CC.email_NhaCC = obj.email_NhaCC;
nha_CC.address_NhaCC = obj.address_NhaCC;
entities.SaveChanges();
return(true);
}
}
public static bool Edit_TaiKhoan(TaiKhoan taiKhoan, TT_TaiKhoan tT_TaiKhoan)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
TaiKhoan taiKhoan_Tmp = entities.TaiKhoan.Where(p => p.user_Acc == taiKhoan.user_Acc).FirstOrDefault();
taiKhoan_Tmp.status = taiKhoan.status;
taiKhoan_Tmp.id_LoaiTK = taiKhoan.id_LoaiTK;
TT_TaiKhoan tT_TaiKhoan_Tmp = entities.TT_TaiKhoan.Where(p => p.user_Acc == taiKhoan.user_Acc).FirstOrDefault();
tT_TaiKhoan_Tmp.name_User = tT_TaiKhoan.name_User;
tT_TaiKhoan_Tmp.phone_User = tT_TaiKhoan.phone_User;
tT_TaiKhoan_Tmp.email_User = tT_TaiKhoan.email_User;
tT_TaiKhoan_Tmp.address_User = tT_TaiKhoan.address_User;
entities.SaveChanges();
return(true);
}
}
public static bool Edit_DanhMuc(DanhMuc obj)
{
using (ThanhHa_MotorCycleEntities entities = new ThanhHa_MotorCycleEntities())
{
DanhMuc danhMuc = entities.DanhMuc.Where(p => p.id_DanhMuc == obj.id_DanhMuc).FirstOrDefault();
danhMuc.name_DanhMuc = obj.name_DanhMuc;
danhMuc.breakend_DanhMuc = obj.breakend_DanhMuc;
danhMuc.breakfont_DanhMuc = obj.breakfont_DanhMuc;
danhMuc.engine_DanhMuc = obj.engine_DanhMuc;
danhMuc.size_DanhMuc = obj.size_DanhMuc;
danhMuc.price_DanhMuc = obj.price_DanhMuc;
danhMuc.volume_DanhMuc = obj.volume_DanhMuc;
danhMuc.tire_DanhMuc = obj.tire_DanhMuc;
danhMuc.torque_DanhMuc = obj.torque_DanhMuc;
danhMuc.weight_DanhMuc = obj.weight_DanhMuc;
danhMuc.id_BaoHanh = obj.id_BaoHanh;
danhMuc.id_HangSX = obj.id_HangSX;
danhMuc.id_LoaiSP = obj.id_LoaiSP;
danhMuc.image_DanhMuc = obj.image_DanhMuc;
entities.SaveChanges();
}
return(true);
}
