public static KhuyenMai Insert(KhuyenMai item) { var Item = new KhuyenMai(); var obj = new SqlParameter[16]; obj[0] = new SqlParameter("KM_ID", item.ID); obj[1] = new SqlParameter("KM_Ten", item.Ten); obj[2] = new SqlParameter("KM_MoTa", item.MoTa); obj[3] = new SqlParameter("KM_Ma", item.Ma); obj[4] = new SqlParameter("KM_NoiDung", item.NoiDung); if (item.TuNgay > DateTime.MinValue) { obj[5] = new SqlParameter("KM_TuNgay", item.TuNgay); } else { obj[5] = new SqlParameter("KM_TuNgay", DBNull.Value); } if (item.DenNgay > DateTime.MinValue) { obj[6] = new SqlParameter("KM_DenNgay", item.DenNgay); } else { obj[6] = new SqlParameter("KM_DenNgay", DBNull.Value); } obj[7] = new SqlParameter("KM_SoLuong", item.SoLuong); obj[8] = new SqlParameter("KM_ChietKhau", item.ChietKhau); obj[9] = new SqlParameter("KM_TienChietKhau", item.TienChietKhau); obj[10] = new SqlParameter("KM_Active", item.Active); obj[11] = new SqlParameter("KM_ThuTu", item.ThuTu); if (item.NgayTao > DateTime.MinValue) { obj[12] = new SqlParameter("KM_NgayTao", item.NgayTao); } else { obj[12] = new SqlParameter("KM_NgayTao", DBNull.Value); } if (item.NgayCapNhat > DateTime.MinValue) { obj[13] = new SqlParameter("KM_NgayCapNhat", item.NgayCapNhat); } else { obj[13] = new SqlParameter("KM_NgayCapNhat", DBNull.Value); } obj[14] = new SqlParameter("KM_NguoiTao", item.NguoiTao); obj[15] = new SqlParameter("KM_NguoiCapNhat", item.NguoiCapNhat); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_KhuyenMai_Insert_InsertNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static KhuyenMai SelectById(Guid KM_ID) { var Item = new KhuyenMai(); var obj = new SqlParameter[1]; obj[0] = new SqlParameter("KM_ID", KM_ID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_KhuyenMai_Select_SelectById_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static KhuyenMai getFromReader(IDataReader rd) { var Item = new KhuyenMai(); if (rd.FieldExists("KM_ID")) { Item.ID = (Guid)(rd["KM_ID"]); } if (rd.FieldExists("KM_Ten")) { Item.Ten = (String)(rd["KM_Ten"]); } if (rd.FieldExists("KM_MoTa")) { Item.MoTa = (String)(rd["KM_MoTa"]); } if (rd.FieldExists("KM_Ma")) { Item.Ma = (String)(rd["KM_Ma"]); } if (rd.FieldExists("KM_NoiDung")) { Item.NoiDung = (String)(rd["KM_NoiDung"]); } if (rd.FieldExists("KM_TuNgay")) { Item.TuNgay = (DateTime)(rd["KM_TuNgay"]); } if (rd.FieldExists("KM_DenNgay")) { Item.DenNgay = (DateTime)(rd["KM_DenNgay"]); } if (rd.FieldExists("KM_SoLuong")) { Item.SoLuong = (Int32)(rd["KM_SoLuong"]); } if (rd.FieldExists("KM_ChietKhau")) { Item.ChietKhau = (Double)(rd["KM_ChietKhau"]); } if (rd.FieldExists("KM_TienChietKhau")) { Item.TienChietKhau = (Double)(rd["KM_TienChietKhau"]); } if (rd.FieldExists("KM_Active")) { Item.Active = (Boolean)(rd["KM_Active"]); } if (rd.FieldExists("KM_ThuTu")) { Item.ThuTu = (Int32)(rd["KM_ThuTu"]); } if (rd.FieldExists("KM_NgayTao")) { Item.NgayTao = (DateTime)(rd["KM_NgayTao"]); } if (rd.FieldExists("KM_NgayCapNhat")) { Item.NgayCapNhat = (DateTime)(rd["KM_NgayCapNhat"]); } if (rd.FieldExists("KM_NguoiTao")) { Item.NguoiTao = (String)(rd["KM_NguoiTao"]); } if (rd.FieldExists("KM_NguoiCapNhat")) { Item.NguoiCapNhat = (String)(rd["KM_NguoiCapNhat"]); } return(Item); }