private static SqlParameter[] CreateSqlParameter(ls_PayrollDOWS_RBVH model) { return(new SqlParameter[] { new SqlParameter("@Dow_ID", model.Dow_ID), new SqlParameter("@Dow_Code", model.Dow_Code), new SqlParameter("@Beg_Day", model.Beg_Day), new SqlParameter("@End_Day", model.End_Day), new SqlParameter("@Dow_Num", model.Dow_Num), new SqlParameter("@ENtityID", model.ENtityID), }); }
public static ls_PayrollDOWS_RBVH AddItem(ls_PayrollDOWS_RBVH model) { int result = 0; using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, CommandType.StoredProcedure, "ls_PayrollDOWS_RBVH_Add", CreateSqlParameter(model))) { while (reader.Read()) { result = (int)reader[0]; } } return(GetItemByID(result)); }
public static ls_PayrollDOWS_RBVH GetItemByID(int ENtityID) { ls_PayrollDOWS_RBVH item = new ls_PayrollDOWS_RBVH(); var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@Dow_ID", ENtityID); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "ls_PayrollDOWS_RBVH_GetByID", sqlParams)) { while (reader.Read()) { item = GetItemFromReader(reader); } } return(item); }
public static ls_PayrollDOWS_RBVHCollection Search(SearchFilter SearchKey) { ls_PayrollDOWS_RBVHCollection collection = new ls_PayrollDOWS_RBVHCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "ls_PayrollDOWS_RBVH_Search", SearchFilterManager.SqlSearchParamNoCompany(SearchKey))) { while (reader.Read()) { ls_PayrollDOWS_RBVH obj = new ls_PayrollDOWS_RBVH(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static ls_PayrollDOWS_RBVHCollection GetAllItemByEntity(int EntityID) { ls_PayrollDOWS_RBVHCollection collection = new ls_PayrollDOWS_RBVHCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "ls_PayrollDOWS_RBVH_GetAll_ByEntity", new SqlParameter("@EntityID", EntityID))) { while (reader.Read()) { ls_PayrollDOWS_RBVH obj = new ls_PayrollDOWS_RBVH(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
private static ls_PayrollDOWS_RBVH GetItemFromReader(IDataReader dataReader) { ls_PayrollDOWS_RBVH objItem = new ls_PayrollDOWS_RBVH(); objItem.Dow_ID = SqlHelper.GetInt(dataReader, "Dow_ID"); objItem.Dow_Code = SqlHelper.GetString(dataReader, "Dow_Code"); objItem.Beg_Day = SqlHelper.GetDateTime(dataReader, "Beg_Day"); objItem.End_Day = SqlHelper.GetDateTime(dataReader, "End_Day"); // objItem.Dow_Num = SqlHelper.GetInt(dataReader, "Dow_Num"); objItem.ENtityID = SqlHelper.GetInt(dataReader, "ENtityID"); if (SqlHelper.ColumnExists(dataReader, "TotalRecord")) { objItem.TotalRecord = SqlHelper.GetInt(dataReader, "TotalRecord"); } return(objItem); }