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);
}
