private static T_CMS_Static_PeriodOfProbation GetItemFromReader(IDataReader dataReader) { T_CMS_Static_PeriodOfProbation objItem = new T_CMS_Static_PeriodOfProbation(); objItem.ID = SqlHelper.GetInt(dataReader, "ID"); objItem.EmpSubTypeID = SqlHelper.GetInt(dataReader, "EmpSubTypeID"); objItem.Period = SqlHelper.GetInt(dataReader, "Period"); objItem.PeriodDescription = SqlHelper.GetString(dataReader, "PeriodDescription"); objItem.IsActive = SqlHelper.GetBoolean(dataReader, "IsActive"); objItem.CreatedBy = SqlHelper.GetInt(dataReader, "CreatedBy"); objItem.CreatedDate = SqlHelper.GetDateTime(dataReader, "CreatedDate"); objItem.ModifiedBy = SqlHelper.GetInt(dataReader, "ModifiedBy"); objItem.ModifiedDate = SqlHelper.GetDateTime(dataReader, "ModifiedDate"); if (SqlHelper.ColumnExists(dataReader, "TotalRecord")) { objItem.TotalRecord = SqlHelper.GetInt(dataReader, "TotalRecord"); } return(objItem); }
public static T_CMS_Static_PeriodOfProbation UpdateItem(T_CMS_Static_PeriodOfProbation model) { int result = 0; using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, CommandType.StoredProcedure, "T_CMS_Static_PeriodOfProbation_Update", CreateSqlParameter(model))) { while (reader.Read()) { result = (int)reader[0]; } } return(GetItemByID(result)); }
public static T_CMS_Static_PeriodOfProbation GetItemByID(int ID) { T_CMS_Static_PeriodOfProbation item = new T_CMS_Static_PeriodOfProbation(); var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@ID", ID); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Static_PeriodOfProbation_GetByID", sqlParams)) { while (reader.Read()) { item = GetItemFromReader(reader); } } return(item); }
private static SqlParameter[] CreateSqlParameter(T_CMS_Static_PeriodOfProbation model) { return(new SqlParameter[] { new SqlParameter("@ID", model.ID), new SqlParameter("@EmpSubTypeID", model.EmpSubTypeID), new SqlParameter("@Period", model.Period), new SqlParameter("@PeriodDescription", model.PeriodDescription), new SqlParameter("@IsActive", model.IsActive), new SqlParameter("@CreatedBy", model.CreatedBy), new SqlParameter("@CreatedDate", model.CreatedDate), new SqlParameter("@ModifiedBy", model.ModifiedBy), new SqlParameter("@ModifiedDate", model.ModifiedDate), }); }
public static T_CMS_Static_PeriodOfProbationCollection Search(SearchFilter SearchKey) { T_CMS_Static_PeriodOfProbationCollection collection = new T_CMS_Static_PeriodOfProbationCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Static_PeriodOfProbation_Search", SearchFilterManager.SqlSearchParamNoCompany(SearchKey))) { while (reader.Read()) { T_CMS_Static_PeriodOfProbation obj = new T_CMS_Static_PeriodOfProbation(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_CMS_Static_PeriodOfProbationCollection GetAllItem() { T_CMS_Static_PeriodOfProbationCollection collection = new T_CMS_Static_PeriodOfProbationCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Static_PeriodOfProbation_GetAll", null)) { while (reader.Read()) { T_CMS_Static_PeriodOfProbation obj = new T_CMS_Static_PeriodOfProbation(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }