public static T_LMS_Trans_LeaveStory UpdateItem(T_LMS_Trans_LeaveStory model) { int result = 0; using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, CommandType.StoredProcedure, "T_LMS_Trans_LeaveStory_Update", CreateSqlParameter(model))) { while (reader.Read()) { result = (int)reader[0]; } } return(GetItemByID(result)); }
public static T_LMS_Trans_LeaveStoryCollection Search(SearchFilter SearchKey) { T_LMS_Trans_LeaveStoryCollection collection = new T_LMS_Trans_LeaveStoryCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_LMS_Trans_LeaveStory_Search", SearchFilterManager.SqlSearchConditionNoCompany(SearchKey))) { while (reader.Read()) { T_LMS_Trans_LeaveStory obj = new T_LMS_Trans_LeaveStory(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_LMS_Trans_LeaveStoryCollection GetAllItem() { T_LMS_Trans_LeaveStoryCollection collection = new T_LMS_Trans_LeaveStoryCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_LMS_Trans_LeaveStory_GetAll", null)) { while (reader.Read()) { T_LMS_Trans_LeaveStory obj = new T_LMS_Trans_LeaveStory(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_LMS_Trans_LeaveStory GetItemByID(int Id) { T_LMS_Trans_LeaveStory item = new T_LMS_Trans_LeaveStory(); var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@Id", Id); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_LMS_Trans_LeaveStory_GetByID", sqlParams)) { while (reader.Read()) { item = GetItemFromReader(reader); } } return(item); }
private static SqlParameter[] CreateSqlParameter(T_LMS_Trans_LeaveStory model) { return(new SqlParameter[] { new SqlParameter("@Id", model.Id), new SqlParameter("@EmployeeCode", model.EmployeeCode), new SqlParameter("@LeaveTypeId", model.LeaveTypeId), new SqlParameter("@StartDate", model.StartDate), new SqlParameter("@EndDate", model.EndDate), new SqlParameter("@FromTime", model.FromTime), new SqlParameter("@ToTime", model.ToTime), new SqlParameter("@NoOfDays", model.NoOfDays), new SqlParameter("@NoOfHours", model.NoOfHours), new SqlParameter("@HalfDayPart", model.HalfDayPart), new SqlParameter("@Remarks", model.Remarks), new SqlParameter("@ApproverComments", model.ApproverComments), new SqlParameter("@StatusId", model.StatusId), new SqlParameter("@ApprovalLevel", model.ApprovalLevel), new SqlParameter("@IsUpdatedByAdmin", model.IsUpdatedByAdmin), new SqlParameter("@IsOverriddenLeave", model.IsOverriddenLeave), new SqlParameter("@OverriddenLeaveId", model.OverriddenLeaveId), new SqlParameter("@IsNC", model.IsNC), new SqlParameter("@OldStatusId", model.OldStatusId), new SqlParameter("@OldApprovalLevelId", model.OldApprovalLevelId), new SqlParameter("@IsAcitve", model.IsAcitve), new SqlParameter("@CreatedBy", model.CreatedBy), new SqlParameter("@CreatedDate", model.CreatedDate), new SqlParameter("@ModifiedBy", model.ModifiedBy), new SqlParameter("@ModifiedDate", model.ModifiedDate), new SqlParameter("@Ref_RequestId", model.Ref_RequestId), new SqlParameter("@UploadStatus", model.UploadStatus), new SqlParameter("@LastUploadDate", model.LastUploadDate), new SqlParameter("@LastUploadedToDate", model.LastUploadedToDate), new SqlParameter("@NextLevelId", model.NextLevelId), new SqlParameter("@NextApproverRoleId", model.NextApproverRoleId), new SqlParameter("@CancelRequestCreatedOn", model.CancelRequestCreatedOn), }); }
private static T_LMS_Trans_LeaveStory GetItemFromReader(IDataReader dataReader) { T_LMS_Trans_LeaveStory objItem = new T_LMS_Trans_LeaveStory(); objItem.Id = SqlHelper.GetInt(dataReader, "Id"); objItem.EmployeeCode = SqlHelper.GetInt(dataReader, "EmployeeCode"); objItem.LeaveTypeId = SqlHelper.GetInt(dataReader, "LeaveTypeId"); objItem.StartDate = SqlHelper.GetDateTime(dataReader, "StartDate"); objItem.EndDate = SqlHelper.GetDateTime(dataReader, "EndDate"); objItem.FromTime = SqlHelper.GetDateTime(dataReader, "FromTime"); objItem.ToTime = SqlHelper.GetDateTime(dataReader, "ToTime"); objItem.NoOfDays = SqlHelper.GetDecimal(dataReader, "NoOfDays"); objItem.NoOfHours = SqlHelper.GetDecimal(dataReader, "NoOfHours"); objItem.HalfDayPart = SqlHelper.GetInt(dataReader, "HalfDayPart"); objItem.Remarks = SqlHelper.GetString(dataReader, "Remarks"); objItem.ApproverComments = SqlHelper.GetString(dataReader, "ApproverComments"); objItem.StatusId = SqlHelper.GetInt(dataReader, "StatusId"); objItem.ApprovalLevel = SqlHelper.GetInt(dataReader, "ApprovalLevel"); objItem.IsUpdatedByAdmin = SqlHelper.GetBoolean(dataReader, "IsUpdatedByAdmin"); objItem.IsOverriddenLeave = SqlHelper.GetBoolean(dataReader, "IsOverriddenLeave"); objItem.OverriddenLeaveId = SqlHelper.GetInt(dataReader, "OverriddenLeaveId"); objItem.IsNC = SqlHelper.GetBoolean(dataReader, "IsNC"); objItem.OldStatusId = SqlHelper.GetInt(dataReader, "OldStatusId"); objItem.OldApprovalLevelId = SqlHelper.GetInt(dataReader, "OldApprovalLevelId"); objItem.IsAcitve = SqlHelper.GetBoolean(dataReader, "IsAcitve"); 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.Ref_RequestId = SqlHelper.GetInt(dataReader, "Ref_RequestId"); objItem.UploadStatus = SqlHelper.GetInt(dataReader, "UploadStatus"); objItem.LastUploadDate = SqlHelper.GetDateTime(dataReader, "LastUploadDate"); objItem.LastUploadedToDate = SqlHelper.GetDateTime(dataReader, "LastUploadedToDate"); objItem.NextLevelId = SqlHelper.GetString(dataReader, "NextLevelId"); objItem.NextApproverRoleId = SqlHelper.GetString(dataReader, "NextApproverRoleId"); objItem.CancelRequestCreatedOn = SqlHelper.GetDateTime(dataReader, "CancelRequestCreatedOn"); if (SqlHelper.ColumnExists(dataReader, "TotalRecord")) { objItem.TotalRecord = SqlHelper.GetInt(dataReader, "TotalRecord"); } return(objItem); }