public static TuVanLamDichVu Insert(TuVanLamDichVu item) { var Item = new TuVanLamDichVu(); var obj = new SqlParameter[6]; obj[0] = new SqlParameter("LDV_ID", item.ID); obj[1] = new SqlParameter("LDV_TVDV_ID", item.TVDV_ID); obj[2] = new SqlParameter("LDV_KH_ID", item.KH_ID); obj[3] = new SqlParameter("LDV_NhanVien", item.NhanVien); if (item.NgayLam > DateTime.MinValue) { obj[4] = new SqlParameter("LDV_NgayLam", item.NgayLam); } else { obj[4] = new SqlParameter("LDV_NgayLam", DBNull.Value); } obj[5] = new SqlParameter("LDV_ThuTu", item.ThuTu); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_TuVanLamDichVu_Insert_InsertNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static TuVanLamDichVu SelectById(Guid LDV_ID) { var Item = new TuVanLamDichVu(); var obj = new SqlParameter[1]; obj[0] = new SqlParameter("LDV_ID", LDV_ID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_TuVanLamDichVu_Select_SelectById_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static TuVanLamDichVu getFromReader(IDataReader rd) { var Item = new TuVanLamDichVu(); if (rd.FieldExists("LDV_ID")) { Item.ID = (Guid)(rd["LDV_ID"]); } if (rd.FieldExists("LDV_TVDV_ID")) { Item.TVDV_ID = (Guid)(rd["LDV_TVDV_ID"]); } if (rd.FieldExists("LDV_KH_ID")) { Item.KH_ID = (Guid)(rd["LDV_KH_ID"]); } if (rd.FieldExists("LDV_NhanVien")) { Item.NhanVien = (String)(rd["LDV_NhanVien"]); } if (rd.FieldExists("LDV_NgayLam")) { Item.NgayLam = (DateTime)(rd["LDV_NgayLam"]); } if (rd.FieldExists("LDV_ThuTu")) { Item.ThuTu = (Int32)(rd["LDV_ThuTu"]); } if (rd.FieldExists("LDV_NhanVien_Ten")) { Item.NhanVien_Ten = (String)(rd["LDV_NhanVien_Ten"]); } if (rd.FieldExists("LDV_KH_Ten")) { Item.KH_Ten = (String)(rd["LDV_KH_Ten"]); } if (rd.FieldExists("LDV_DV_Ten")) { Item.DV_Ten = (String)(rd["LDV_DV_Ten"]); } Item._TuVanDichVu = TuVanDichVuDal.getFromReader(rd); Item._XuatNhap = XuatNhapDal.getFromReader(rd); return(Item); }