private void DeleteAllCurrentData()
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeMonthlyTimeSheetSummaryEntity.FLD_NAME_SalarySessionID, (Int64.Parse(ddlSalarySessionID.SelectedValue)).ToString(), SQLMatchType.Equal);
HREmployeeMonthlyTimeSheetSummaryEntity HhEmployeeMonthlyTimeSheetSummaryEntity = new HREmployeeMonthlyTimeSheetSummaryEntity();
result = FCCHREmployeeMonthlyTimeSheetSummary.GetFacadeCreate().Delete(HhEmployeeMonthlyTimeSheetSummaryEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_EmployeeMonthlyTimeSheetID = 0;
_HREmployeeMonthlyTimeSheetSummaryEntity = new HREmployeeMonthlyTimeSheetSummaryEntity();
PrepareInitialView();
MiscUtil.ShowMessage(lblMessage, "Time Sheet has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Time Sheet.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
Int64 IHREmployeeMonthlyTimeSheetSummaryDataAccess.Add(HREmployeeMonthlyTimeSheetSummaryEntity hREmployeeMonthlyTimeSheetSummaryEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
try
{
long retValues = -99;
switch (reqTran)
{
case TransactionRequired.No:
{
retValues = Add(hREmployeeMonthlyTimeSheetSummaryEntity, option);
break;
}
case TransactionRequired.Yes:
{
retValues = AddTran(hREmployeeMonthlyTimeSheetSummaryEntity, option);
break;
}
default:
{
retValues = -99;
break;
}
}
return(retValues);
}
catch (Exception ex)
{
throw ex;
}
}
private void SaveHREmployeeMonthlyTimeSheetSummaryEntity()
{
if (IsValid)
{
try
{
HREmployeeMonthlyTimeSheetSummaryEntity hREmployeeMonthlyTimeSheetSummaryEntity = new HREmployeeMonthlyTimeSheetSummaryEntity();//BuildHREmployeeMonthlyTimeSheetSummaryEntity();
Int64 result = -1;
if (hREmployeeMonthlyTimeSheetSummaryEntity.IsNew)
{
result = FCCHREmployeeMonthlyTimeSheetSummary.GetFacadeCreate().Add(hREmployeeMonthlyTimeSheetSummaryEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeMonthlyTimeSheetSummaryEntity.FLD_NAME_EmployeeMonthlyTimeSheetID, hREmployeeMonthlyTimeSheetSummaryEntity.EmployeeMonthlyTimeSheetID.ToString(), SQLMatchType.Equal);
result = FCCHREmployeeMonthlyTimeSheetSummary.GetFacadeCreate().Update(hREmployeeMonthlyTimeSheetSummaryEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
_EmployeeMonthlyTimeSheetID = 0;
_HREmployeeMonthlyTimeSheetSummaryEntity = new HREmployeeMonthlyTimeSheetSummaryEntity();
PrepareInitialView();
BindHREmployeeMonthlyTimeSheetSummaryList();
if (hREmployeeMonthlyTimeSheetSummaryEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Employee Monthly Time Sheet Summary Information has been added successfully.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Employee Monthly Time Sheet Summary Information has been updated successfully.", false);
}
}
else
{
if (hREmployeeMonthlyTimeSheetSummaryEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Employee Monthly Time Sheet Summary Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Employee Monthly Time Sheet Summary Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
private Int64 DeleteTran(HREmployeeMonthlyTimeSheetSummaryEntity hREmployeeMonthlyTimeSheetSummaryEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.HREmployeeMonthlyTimeSheetSummary_SET";
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand cmd = db.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd, db);
AddFilterExpressionParameter(cmd, filterExpression, db);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
using (IDataReader reader = db.ExecuteReader(cmd, transaction))
{
returnCode = GetReturnCodeFromParameter(cmd);
}
if (returnCode >= 0)
{
transaction.Commit();
}
else
{
throw new ArgumentException("Error Code." + returnCode.ToString());
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
transaction.Dispose();
connection.Close();
connection = null;
}
}
return(returnCode);
}
private Int64 Delete(HREmployeeMonthlyTimeSheetSummaryEntity hREmployeeMonthlyTimeSheetSummaryEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.HREmployeeMonthlyTimeSheetSummary_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddFilterExpressionParameter(cmd, filterExpression);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("HREmployeeMonthlyTimeSheetSummaryEntity already exists. Please specify another HREmployeeMonthlyTimeSheetSummaryEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("HREmployeeMonthlyTimeSheetSummaryEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("HREmployeeMonthlyTimeSheetSummaryEntity already exists. Please specify another HREmployeeMonthlyTimeSheetSummaryEntity.");
}
}
}
}
return(returnCode);
}
Int64 IHREmployeeMonthlyTimeSheetSummaryFacade.Delete(HREmployeeMonthlyTimeSheetSummaryEntity hREmployeeMonthlyTimeSheetSummaryEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateHREmployeeMonthlyTimeSheetSummaryDataAccess().Delete(hREmployeeMonthlyTimeSheetSummaryEntity, filterExpression, option, reqTran));
}
Int64 IHREmployeeMonthlyTimeSheetSummaryFacade.Add(HREmployeeMonthlyTimeSheetSummaryEntity hREmployeeMonthlyTimeSheetSummaryEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateHREmployeeMonthlyTimeSheetSummaryDataAccess().Add(hREmployeeMonthlyTimeSheetSummaryEntity, option, reqTran));
}
protected void btnAddNew_Click(object sender, EventArgs e)
{
_EmployeeMonthlyTimeSheetID = 0;
_HREmployeeMonthlyTimeSheetSummaryEntity = new HREmployeeMonthlyTimeSheetSummaryEntity();
PrepareInitialView();
}
private void GenerateAll()
{
try
{
StringBuilder xmlStr = new StringBuilder();
Int64 employmentStatusID = 1;
String fe = SqlExpressionBuilder.PrepareFilterExpression("(HREmployeeSalaryInfo.SalaryAmount is not null and HREmployeeSalaryInfo.FiscalYearID = (Select FiscalYearID from ACFiscalYear where IsClosed = 0)) and HREmployee." + HREmployee_DetailedEntity.FLD_NAME_EmploymentStatusID, employmentStatusID.ToString(), SQLMatchType.Equal);
if (ddlDepartmentID.SelectedValue == "1")
{
String fe2 = "( HREmployee.DepartmentID is null or HREmployee.DepartmentID <> 20)";
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe2);
}
else
{
String fe3 = "(HREmployee.DepartmentID = 20)";
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe3);
}
IList <HREmployee_DetailedEntity> list = FCCHREmployeeMonthlyTimeSheet_Detailed.GetFacadeCreate().GetIL(1000, 1, String.Empty, fe);
xmlStr.Append("<m>");
if (list != null && list.Count > 0)
{
foreach (HREmployee_DetailedEntity hREmployee_DetailedEntity in list)
{
HREmployeeMonthlyTimeSheetSummaryEntity hREmployeeMonthlyTimeSheetSummaryEntity = new HREmployeeMonthlyTimeSheetSummaryEntity();
hREmployeeMonthlyTimeSheetSummaryEntity.LCASUAL = 0;
hREmployeeMonthlyTimeSheetSummaryEntity.LMEDICAL = 0;
hREmployeeMonthlyTimeSheetSummaryEntity.EARNLEAVE = 0;
hREmployeeMonthlyTimeSheetSummaryEntity.LWP = 0;
hREmployeeMonthlyTimeSheetSummaryEntity.REMARKS = String.Empty;
hREmployeeMonthlyTimeSheetSummaryEntity.NUMBEROFMEALS = 0;
hREmployeeMonthlyTimeSheetSummaryEntity.PROJECTACTUAL = 0;
hREmployeeMonthlyTimeSheetSummaryEntity.OTHERLEAVE = 0;
String remarks = String.Empty;
IList <HREmployeeDetailsForMonthlyTimeSheetSummary_CustomEntity> entList = FCCHREmployeeDetailsForMonthlyTimeSheetSummary_Custom.GetFacadeCreate().GetIL(Int64.Parse(ddlSalarySessionID.SelectedValue));
hREmployeeMonthlyTimeSheetSummaryEntity.OnJob = entList[0].OnJob;
hREmployeeMonthlyTimeSheetSummaryEntity.Holiday = (entList[0].Holiday - entList[0].LeaveDay);
hREmployeeMonthlyTimeSheetSummaryEntity.ACTUALWORKDAYS = ((hREmployeeMonthlyTimeSheetSummaryEntity.OnJob + hREmployeeMonthlyTimeSheetSummaryEntity.Holiday) - hREmployeeMonthlyTimeSheetSummaryEntity.LWP);
Int64 employeeID = hREmployee_DetailedEntity.EmployeeID;
Decimal totalLeaveDays = 0;
Decimal casual = 0;
Decimal medical = 0;
Decimal earn = 0;
Decimal lwp = 0;
String fe1 = SqlExpressionBuilder.PrepareFilterExpression(" HREmployee." + HREmployee_DetailedEntity.FLD_NAME_EmployeeID, employeeID.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression(MDSalarySessionEntity.FLD_NAME_SalarySessionID, (Int64.Parse(ddlSalarySessionID.SelectedValue)).ToString(), SQLMatchType.Equal);
String fe3 = SqlExpressionBuilder.PrepareFilterExpression("HREmployeeLeaveApplication." + HREmployeeLeaveApplicationEntity.FLD_NAME_LeaveApplicationApplicationStatusID, MasterDataConstants.MDLeaveApplicatoinStatus.APPROVED.ToString(), SQLMatchType.Equal);
String f = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
f = SqlExpressionBuilder.PrepareFilterExpression(f, SQLJoinType.AND, fe3);
IList <HREmployeeLeaveApplication_DetailedEntity> leaveList = FCCHREmployeeLeaveApplication_Detailed.GetFacadeCreate().GetIL(1000, 1, String.Empty, f);
if (leaveList != null && leaveList.Count > 0)
{
foreach (HREmployeeLeaveApplication_DetailedEntity entity in leaveList)
{
if (entity.LeaveCategoryID == MasterDataConstants.MDLeaveCategory.CASUAL)
{
casual += leaveList[0].TotalLeaveDays;
}
else if (entity.LeaveCategoryID == MasterDataConstants.MDLeaveCategory.MEDICAL)
{
medical += leaveList[0].TotalLeaveDays;
}
else if (entity.LeaveCategoryID == MasterDataConstants.MDLeaveCategory.EARN)
{
earn += leaveList[0].TotalLeaveDays;
}
else if (entity.LeaveCategoryID == MasterDataConstants.MDLeaveCategory.LWP)
{
lwp += leaveList[0].TotalLeaveDays;
}
}
}
if (lwp > 0)
{
remarks += lwp + " LWP " + (lwp * 6) + " Late. ";
}
totalLeaveDays = casual + medical + earn;
if (totalLeaveDays > 0)
{
remarks += totalLeaveDays.ToString().Trim() + " Leave.";
}
else
{
remarks += String.Empty;
}
hREmployeeMonthlyTimeSheetSummaryEntity.LCASUAL = casual;
hREmployeeMonthlyTimeSheetSummaryEntity.LMEDICAL = medical;
hREmployeeMonthlyTimeSheetSummaryEntity.EARNLEAVE = earn;
hREmployeeMonthlyTimeSheetSummaryEntity.LWP = lwp;
hREmployeeMonthlyTimeSheetSummaryEntity.ACTUALWORKDAYS = (entList[0].ActualWorkingDay - lwp);
hREmployeeMonthlyTimeSheetSummaryEntity.REMARKS = remarks;
hREmployeeMonthlyTimeSheetSummaryEntity.SalarySessionID = Int64.Parse(ddlSalarySessionID.SelectedValue);
#region Already Has this employee
Boolean isTrue = true;
String fe4 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeMonthlyTimeSheetSummaryEntity.FLD_NAME_EmployeeID, employeeID.ToString(), SQLMatchType.Equal);
String fe5 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeMonthlyTimeSheetSummaryEntity.FLD_NAME_SalarySessionID, (Int64.Parse(ddlSalarySessionID.SelectedValue)).ToString(), SQLMatchType.Equal);
String fe6 = SqlExpressionBuilder.PrepareFilterExpression(fe4, SQLJoinType.AND, fe5);
IList <HREmployeeMonthlyTimeSheetSummaryEntity> hREmployeeMonthlyTimeSheetSummarylist = FCCHREmployeeMonthlyTimeSheetSummary.GetFacadeCreate().GetIL(null, null, String.Empty, fe6, DatabaseOperationType.LoadWithFilterExpression);
if (hREmployeeMonthlyTimeSheetSummarylist != null && hREmployeeMonthlyTimeSheetSummarylist.Count > 0)
{
isTrue = false;
}
#endregion
if (isTrue)
{
String subXmlStr = null;
subXmlStr = subXmlStr + "<i><a>" + hREmployee_DetailedEntity.EmployeeID + "</a><b>" + hREmployee_DetailedEntity.DesignationID + "</b><c>" + hREmployee_DetailedEntity.EmployeeJobTypeID + "</c><d>" + hREmployee_DetailedEntity.SalaryLevel + "</d><e>" + hREmployeeMonthlyTimeSheetSummaryEntity.SalarySessionID + "</e><f>" + hREmployeeMonthlyTimeSheetSummaryEntity.OnJob + "</f><g>" + hREmployeeMonthlyTimeSheetSummaryEntity.Holiday + "</g><h>" + hREmployeeMonthlyTimeSheetSummaryEntity.LCASUAL + "</h><i1>" + hREmployeeMonthlyTimeSheetSummaryEntity.LMEDICAL + "</i1><j>" + hREmployeeMonthlyTimeSheetSummaryEntity.EARNLEAVE + "</j><k>" + hREmployeeMonthlyTimeSheetSummaryEntity.LWP + "</k><l>" + hREmployeeMonthlyTimeSheetSummaryEntity.ACTUALWORKDAYS + "</l><m>" + hREmployeeMonthlyTimeSheetSummaryEntity.REMARKS + "</m><n>" + hREmployeeMonthlyTimeSheetSummaryEntity.NUMBEROFMEALS + "</n><o>" + hREmployeeMonthlyTimeSheetSummaryEntity.PROJECTACTUAL + "</o><p>" + hREmployeeMonthlyTimeSheetSummaryEntity.OTHERLEAVE + "</p><q>" + hREmployee_DetailedEntity.DepartmentID + "</q></i>";
xmlStr.Append(subXmlStr.ToString());
}
}
}
xmlStr.Append("</m>");
FCCBulkInsertXML.GetFacadeCreate().GetIL(xmlStr.ToString(), CommonConstants.HREmployeeMonthlyTimeSheetSummary);
MiscUtil.ShowMessage(lblMessage, "Time Sheet Has been Generated Successfully.", false);
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, "An Error Occoured.", true);
}
}
private void UpdateHREmployeeDetailsForMonthlyTimeSheetSummary()
{
try
{
IList <ListViewDataItem> list = lvHREmployeeDetailsForMonthlyTimeSheetSummary.Items;
if (list != null && list.Count > 0)
{
Int32 tempDataItemIndex = 0;
foreach (ListViewDataItem lvdi in list)
{
DataKey currentDataKey = lvHREmployeeDetailsForMonthlyTimeSheetSummary.DataKeys[tempDataItemIndex++];
Int64 _employeeID = (Int64)currentDataKey["EmployeeID"];
Boolean isSaveFlag = true;
String fe1 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeMonthlyTimeSheetSummaryEntity.FLD_NAME_EmployeeID, _employeeID.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeMonthlyTimeSheetSummaryEntity.FLD_NAME_SalarySessionID, ddlSalarySessionID.SelectedValue.ToString(), SQLMatchType.Equal);
String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
IList <HREmployeeMonthlyTimeSheetSummaryEntity> lstHREmployeeMonthlyTimeSheetSummary = FCCHREmployeeMonthlyTimeSheetSummary.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);
if (lstHREmployeeMonthlyTimeSheetSummary != null && lstHREmployeeMonthlyTimeSheetSummary.Count > 0)
{
isSaveFlag = false;
}
//String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeMonthlyTimeSheetSummaryEntity.em)
HREmployee_DetailedEntity employeeEntity = GetHREmployeeInfo(_employeeID);
TextBox txtEmployeeName = (TextBox)lvdi.FindControl("txtEmployeeName");
TextBox txtDesignation = (TextBox)lvdi.FindControl("txtDesignation");
TextBox txtEmployeeJobTypeID = (TextBox)lvdi.FindControl("txtEmployeeJobTypeID");
TextBox txtSalaryLevel = (TextBox)lvdi.FindControl("txtSalaryLevel");
TextBox txtOnJob = (TextBox)lvdi.FindControl("txtOnJob");
TextBox txtHoliday = (TextBox)lvdi.FindControl("txtHoliday");
TextBox txtLCASUAL = (TextBox)lvdi.FindControl("txtLCASUAL");
TextBox txtLMEDICAL = (TextBox)lvdi.FindControl("txtLMEDICAL");
TextBox txtEARNLEAVE = (TextBox)lvdi.FindControl("txtEARNLEAVE");
TextBox txtLWP = (TextBox)lvdi.FindControl("txtLWP");
TextBox txtACTUALWORKDAYS = (TextBox)lvdi.FindControl("txtACTUALWORKDAYS");
TextBox txtREMARKS = (TextBox)lvdi.FindControl("txtREMARKS");
TextBox txtNUMBEROFMEALS = (TextBox)lvdi.FindControl("txtNUMBEROFMEALS");
TextBox txtPROJECTACTUAL = (TextBox)lvdi.FindControl("txtPROJECTACTUAL");
TextBox txtOTHERLEAVE = (TextBox)lvdi.FindControl("txtEARNLEAVE");
Label lbldepartmentID = (Label)lvdi.FindControl("lbldepartmentID");
String remarks = String.Empty;
Decimal totalLeave = Decimal.Parse(txtLCASUAL.Text) + Decimal.Parse(txtLMEDICAL.Text) + Decimal.Parse(txtEARNLEAVE.Text);
Decimal actualWorkingdays = (Decimal.Parse(txtOnJob.Text) + Decimal.Parse(txtHoliday.Text)) - Decimal.Parse(txtLWP.Text);
if (txtLWP.Text.IsNotNullOrEmpty() && Decimal.Parse(txtLWP.Text) > 0)
{
remarks += txtLWP.Text + " LWP for " + (Decimal.Parse(txtLWP.Text) * 6) + " Late. ";
}
if (totalLeave > 0)
{
remarks += totalLeave + " Leave";
}
txtREMARKS.Text = remarks;
HREmployeeMonthlyTimeSheetSummaryEntity hREmployeeMonthlyTimeSheetSummaryEntity = new HREmployeeMonthlyTimeSheetSummaryEntity();
hREmployeeMonthlyTimeSheetSummaryEntity.EmployeeID = employeeEntity.EmployeeID;
hREmployeeMonthlyTimeSheetSummaryEntity.DesignationID = employeeEntity.DesignationID;
hREmployeeMonthlyTimeSheetSummaryEntity.EmployeeJobTypeID = employeeEntity.EmployeeJobTypeID;
hREmployeeMonthlyTimeSheetSummaryEntity.OnJob = Decimal.Parse(txtOnJob.Text);
hREmployeeMonthlyTimeSheetSummaryEntity.Holiday = Decimal.Parse(txtHoliday.Text);
hREmployeeMonthlyTimeSheetSummaryEntity.LCASUAL = Decimal.Parse(txtLCASUAL.Text);
hREmployeeMonthlyTimeSheetSummaryEntity.LMEDICAL = Decimal.Parse(txtLMEDICAL.Text);
hREmployeeMonthlyTimeSheetSummaryEntity.LWP = Decimal.Parse(txtLWP.Text);
hREmployeeMonthlyTimeSheetSummaryEntity.EARNLEAVE = Decimal.Parse(txtEARNLEAVE.Text);
hREmployeeMonthlyTimeSheetSummaryEntity.ACTUALWORKDAYS = actualWorkingdays;
hREmployeeMonthlyTimeSheetSummaryEntity.REMARKS = txtREMARKS.Text.ToString().Trim();
hREmployeeMonthlyTimeSheetSummaryEntity.NUMBEROFMEALS = Decimal.Parse(txtNUMBEROFMEALS.Text);
hREmployeeMonthlyTimeSheetSummaryEntity.PROJECTACTUAL = Decimal.Parse(txtPROJECTACTUAL.Text);
hREmployeeMonthlyTimeSheetSummaryEntity.OTHERLEAVE = Decimal.Parse(txtOTHERLEAVE.Text);
hREmployeeMonthlyTimeSheetSummaryEntity.SalarySessionID = Int64.Parse(ddlSalarySessionID.SelectedValue);
hREmployeeMonthlyTimeSheetSummaryEntity.DepartmentID = Int64.Parse(lbldepartmentID.Text);
if (txtSalaryLevel.Text.IsNotNullOrEmpty())
{
hREmployeeMonthlyTimeSheetSummaryEntity.SalaryLevel = Int32.Parse(txtSalaryLevel.Text);
}
else
{
hREmployeeMonthlyTimeSheetSummaryEntity.SalaryLevel = null;
}
if (isSaveFlag)
{
FCCHREmployeeMonthlyTimeSheetSummary.GetFacadeCreate().Add(hREmployeeMonthlyTimeSheetSummaryEntity, DatabaseOperationType.Add, TransactionRequired.No);
MiscUtil.ShowMessage(lblMessage, "Employee Monthly Time Sheet Summary Information has been saved successfully.", false);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeMonthlyTimeSheetSummaryEntity.FLD_NAME_EmployeeMonthlyTimeSheetID, lstHREmployeeMonthlyTimeSheetSummary[0].EmployeeMonthlyTimeSheetID.ToString(), SQLMatchType.Equal);
FCCHREmployeeMonthlyTimeSheetSummary.GetFacadeCreate().Update(hREmployeeMonthlyTimeSheetSummaryEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
MiscUtil.ShowMessage(lblMessage, "Employee Monthly Time Sheet Summary Information has been updated successfully.", false);
}
BindList();
//PrepareInitialView();
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, "Failed to Employee Monthly Time Sheet Summary Information.", true);
}
}
private Int64 Add(HREmployeeMonthlyTimeSheetSummaryEntity hREmployeeMonthlyTimeSheetSummaryEntity, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.HREmployeeMonthlyTimeSheetSummary_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddNullPrimaryKeyParameter(cmd, "EmployeeMonthlyTimeSheetID");
Database.AddInParameter(cmd, "@EmployeeID", DbType.Int64, hREmployeeMonthlyTimeSheetSummaryEntity.EmployeeID);
Database.AddInParameter(cmd, "@DesignationID", DbType.Int64, hREmployeeMonthlyTimeSheetSummaryEntity.DesignationID);
Database.AddInParameter(cmd, "@EmployeeJobTypeID", DbType.Int64, hREmployeeMonthlyTimeSheetSummaryEntity.EmployeeJobTypeID);
Database.AddInParameter(cmd, "@SalaryLevel", DbType.Int32, hREmployeeMonthlyTimeSheetSummaryEntity.SalaryLevel);
Database.AddInParameter(cmd, "@SalarySessionID", DbType.Int64, hREmployeeMonthlyTimeSheetSummaryEntity.SalarySessionID);
Database.AddInParameter(cmd, "@OnJob", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.OnJob);
Database.AddInParameter(cmd, "@Holiday", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.Holiday);
Database.AddInParameter(cmd, "@LCASUAL", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.LCASUAL);
Database.AddInParameter(cmd, "@LMEDICAL", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.LMEDICAL);
Database.AddInParameter(cmd, "@EARNLEAVE", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.EARNLEAVE);
Database.AddInParameter(cmd, "@LWP", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.LWP);
Database.AddInParameter(cmd, "@ACTUALWORKDAYS", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.ACTUALWORKDAYS);
Database.AddInParameter(cmd, "@REMARKS", DbType.String, hREmployeeMonthlyTimeSheetSummaryEntity.REMARKS);
Database.AddInParameter(cmd, "@NUMBEROFMEALS", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.NUMBEROFMEALS);
Database.AddInParameter(cmd, "@PROJECTACTUAL", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.PROJECTACTUAL);
Database.AddInParameter(cmd, "@OTHERLEAVE", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.OTHERLEAVE);
Database.AddInParameter(cmd, "@Field1", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.Field1);
Database.AddInParameter(cmd, "@Field11", DbType.String, hREmployeeMonthlyTimeSheetSummaryEntity.Field11);
Database.AddInParameter(cmd, "@Field12", DbType.String, hREmployeeMonthlyTimeSheetSummaryEntity.Field12);
Database.AddInParameter(cmd, "@Field13", DbType.String, hREmployeeMonthlyTimeSheetSummaryEntity.Field13);
Database.AddInParameter(cmd, "@Field14", DbType.String, hREmployeeMonthlyTimeSheetSummaryEntity.Field14);
Database.AddInParameter(cmd, "@Field15", DbType.String, hREmployeeMonthlyTimeSheetSummaryEntity.Field15);
Database.AddInParameter(cmd, "@DepartmentID", DbType.Int64, hREmployeeMonthlyTimeSheetSummaryEntity.DepartmentID);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("HREmployeeMonthlyTimeSheetSummaryEntity already exists. Please specify another HREmployeeMonthlyTimeSheetSummaryEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("HREmployeeMonthlyTimeSheetSummaryEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("HREmployeeMonthlyTimeSheetSummaryEntity already exists. Please specify another HREmployeeMonthlyTimeSheetSummaryEntity.");
}
}
}
}
return(returnCode);
}
private Int64 UpdateTran(HREmployeeMonthlyTimeSheetSummaryEntity hREmployeeMonthlyTimeSheetSummaryEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.HREmployeeMonthlyTimeSheetSummary_SET";
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand cmd = db.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option, db);
AddOutputParameter(cmd, db);
AddFilterExpressionParameter(cmd, filterExpression, db);
db.AddInParameter(cmd, "@EmployeeMonthlyTimeSheetID", DbType.Int64, hREmployeeMonthlyTimeSheetSummaryEntity.EmployeeMonthlyTimeSheetID);
db.AddInParameter(cmd, "@EmployeeID", DbType.Int64, hREmployeeMonthlyTimeSheetSummaryEntity.EmployeeID);
db.AddInParameter(cmd, "@DesignationID", DbType.Int64, hREmployeeMonthlyTimeSheetSummaryEntity.DesignationID);
db.AddInParameter(cmd, "@EmployeeJobTypeID", DbType.Int64, hREmployeeMonthlyTimeSheetSummaryEntity.EmployeeJobTypeID);
db.AddInParameter(cmd, "@SalaryLevel", DbType.Int32, hREmployeeMonthlyTimeSheetSummaryEntity.SalaryLevel);
db.AddInParameter(cmd, "@SalarySessionID", DbType.Int64, hREmployeeMonthlyTimeSheetSummaryEntity.SalarySessionID);
db.AddInParameter(cmd, "@OnJob", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.OnJob);
db.AddInParameter(cmd, "@Holiday", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.Holiday);
db.AddInParameter(cmd, "@LCASUAL", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.LCASUAL);
db.AddInParameter(cmd, "@LMEDICAL", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.LMEDICAL);
db.AddInParameter(cmd, "@EARNLEAVE", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.EARNLEAVE);
db.AddInParameter(cmd, "@LWP", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.LWP);
db.AddInParameter(cmd, "@ACTUALWORKDAYS", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.ACTUALWORKDAYS);
db.AddInParameter(cmd, "@REMARKS", DbType.String, hREmployeeMonthlyTimeSheetSummaryEntity.REMARKS);
db.AddInParameter(cmd, "@NUMBEROFMEALS", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.NUMBEROFMEALS);
db.AddInParameter(cmd, "@PROJECTACTUAL", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.PROJECTACTUAL);
db.AddInParameter(cmd, "@OTHERLEAVE", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.OTHERLEAVE);
db.AddInParameter(cmd, "@Field1", DbType.Decimal, hREmployeeMonthlyTimeSheetSummaryEntity.Field1);
db.AddInParameter(cmd, "@Field11", DbType.String, hREmployeeMonthlyTimeSheetSummaryEntity.Field11);
db.AddInParameter(cmd, "@Field12", DbType.String, hREmployeeMonthlyTimeSheetSummaryEntity.Field12);
db.AddInParameter(cmd, "@Field13", DbType.String, hREmployeeMonthlyTimeSheetSummaryEntity.Field13);
db.AddInParameter(cmd, "@Field14", DbType.String, hREmployeeMonthlyTimeSheetSummaryEntity.Field14);
db.AddInParameter(cmd, "@Field15", DbType.String, hREmployeeMonthlyTimeSheetSummaryEntity.Field15);
db.AddInParameter(cmd, "@DepartmentID", DbType.Int64, hREmployeeMonthlyTimeSheetSummaryEntity.DepartmentID);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
using (IDataReader reader = db.ExecuteReader(cmd, transaction))
{
returnCode = GetReturnCodeFromParameter(cmd);
}
if (returnCode > 0)
{
transaction.Commit();
}
else
{
throw new ArgumentException("Error Code." + returnCode.ToString());
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
transaction.Dispose();
connection.Close();
connection = null;
}
}
return(returnCode);
}