public static T_COM_Master_Employee_Position UpdateItem(T_COM_Master_Employee_Position model) { int result = 0; using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, CommandType.StoredProcedure, "T_COM_Master_Employee_Position_Update", CreateSqlParameter(model))) { while (reader.Read()) { result = (int)reader[0]; } } return(GetItemByID(result)); }
public static T_COM_Master_Employee_PositionCollection Search(SearchFilter SearchKey) { T_COM_Master_Employee_PositionCollection collection = new T_COM_Master_Employee_PositionCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_COM_Master_Employee_Position_Search", SearchFilterManager.SqlSearchConditionNoCompany(SearchKey))) { while (reader.Read()) { T_COM_Master_Employee_Position obj = new T_COM_Master_Employee_Position(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_COM_Master_Employee_PositionCollection GetAllItem() { T_COM_Master_Employee_PositionCollection collection = new T_COM_Master_Employee_PositionCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_COM_Master_Employee_Position_GetAll", null)) { while (reader.Read()) { T_COM_Master_Employee_Position obj = new T_COM_Master_Employee_Position(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_COM_Master_Employee_Position GetItemByID(int ID) { T_COM_Master_Employee_Position item = new T_COM_Master_Employee_Position(); var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@ID", ID); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_COM_Master_Employee_Position_GetByID", sqlParams)) { while (reader.Read()) { item = GetItemFromReader(reader); } } return(item); }
private static T_COM_Master_Employee_Position GetItemFromReader(IDataReader dataReader) { T_COM_Master_Employee_Position objItem = new T_COM_Master_Employee_Position(); objItem.ID = SqlHelper.GetInt(dataReader, "ID"); objItem.EmployeeCode = SqlHelper.GetInt(dataReader, "EmployeeCode"); objItem.GradeID = SqlHelper.GetInt(dataReader, "GradeID"); objItem.PositionID = SqlHelper.GetInt(dataReader, "PositionID"); objItem.Salary = SqlHelper.GetDecimal(dataReader, "Salary"); objItem.HomeCountrySalary = SqlHelper.GetDecimal(dataReader, "HomeCountrySalary"); objItem.HostCountryCurrency = SqlHelper.GetString(dataReader, "HostCountryCurrency"); objItem.HomeCountryCurrency = SqlHelper.GetString(dataReader, "HomeCountryCurrency"); objItem.EffectiveFrom = SqlHelper.GetDateTime(dataReader, "EffectiveFrom"); objItem.EffectiveTo = SqlHelper.GetDateTime(dataReader, "EffectiveTo"); objItem.CreatedBy = SqlHelper.GetInt(dataReader, "CreatedBy"); objItem.CreatedDate = SqlHelper.GetDateTime(dataReader, "CreatedDate"); objItem.ModifiedBy = SqlHelper.GetInt(dataReader, "ModifiedBy"); objItem.ModifiedDate = SqlHelper.GetDateTime(dataReader, "ModifiedDate"); objItem.IsAcitve = SqlHelper.GetBoolean(dataReader, "IsAcitve"); if (SqlHelper.ColumnExists(dataReader, "TotalRecord")) { objItem.TotalRecord = SqlHelper.GetInt(dataReader, "TotalRecord"); } return(objItem); }
private static SqlParameter[] CreateSqlParameter(T_COM_Master_Employee_Position model) { return(new SqlParameter[] { new SqlParameter("@ID", model.ID), new SqlParameter("@EmployeeCode", model.EmployeeCode), new SqlParameter("@GradeID", model.GradeID), new SqlParameter("@PositionID", model.PositionID), new SqlParameter("@Salary", model.Salary), new SqlParameter("@HomeCountrySalary", model.HomeCountrySalary), new SqlParameter("@HostCountryCurrency", model.HostCountryCurrency), new SqlParameter("@HomeCountryCurrency", model.HomeCountryCurrency), new SqlParameter("@EffectiveFrom", model.EffectiveFrom), new SqlParameter("@EffectiveTo", model.EffectiveTo), new SqlParameter("@CreatedBy", model.CreatedBy), new SqlParameter("@CreatedDate", model.CreatedDate), new SqlParameter("@ModifiedBy", model.ModifiedBy), new SqlParameter("@ModifiedDate", model.ModifiedDate), new SqlParameter("@IsAcitve", model.IsAcitve), }); }