Int64 IHRMemberLeaveOpeningBalanceDataAccess.Add(HRMemberLeaveOpeningBalanceEntity hRMemberLeaveOpeningBalanceEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
try
{
long retValues = -99;
switch (reqTran)
{
case TransactionRequired.No:
{
retValues = Add(hRMemberLeaveOpeningBalanceEntity, option);
break;
}
case TransactionRequired.Yes:
{
retValues = AddTran(hRMemberLeaveOpeningBalanceEntity, option);
break;
}
default:
{
retValues = -99;
break;
}
}
return(retValues);
}
catch (Exception ex)
{
throw ex;
}
}
private void PrepareEditView()
{
HRMemberLeaveOpeningBalanceEntity hRMemberLeaveOpeningBalanceEntity = CurrentHRMemberLeaveOpeningBalanceEntity;
if (!hRMemberLeaveOpeningBalanceEntity.IsNew)
{
if (ddlAttendanceLeaveHolidayListID.Items.Count > 0 && hRMemberLeaveOpeningBalanceEntity.AttendanceLeaveHolidayListID != null)
{
ddlAttendanceLeaveHolidayListID.SelectedValue = hRMemberLeaveOpeningBalanceEntity.AttendanceLeaveHolidayListID.ToString();
}
if (ddlEmployeeID.Items.Count > 0 && hRMemberLeaveOpeningBalanceEntity.EmployeeID != null)
{
ddlEmployeeID.SelectedValue = hRMemberLeaveOpeningBalanceEntity.EmployeeID.ToString();
}
txtBalanceDays.Text = hRMemberLeaveOpeningBalanceEntity.BalanceDays.ToString();
txtBalanceAsOffDate.Text = hRMemberLeaveOpeningBalanceEntity.BalanceAsOffDate.ToStringDefault();
txtRemarks.Text = hRMemberLeaveOpeningBalanceEntity.Remarks.ToString();
btnSubmit.Text = "Update";
btnAddNew.Visible = true;
}
}
private Int64 UpdateTran(HRMemberLeaveOpeningBalanceEntity hRMemberLeaveOpeningBalanceEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.HRMemberLeaveOpeningBalance_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, "@MemberLeaveOpeningBalanceID", DbType.Int64, hRMemberLeaveOpeningBalanceEntity.MemberLeaveOpeningBalanceID);
db.AddInParameter(cmd, "@AttendanceLeaveHolidayListID", DbType.Int64, hRMemberLeaveOpeningBalanceEntity.AttendanceLeaveHolidayListID);
db.AddInParameter(cmd, "@EmployeeID", DbType.Int64, hRMemberLeaveOpeningBalanceEntity.EmployeeID);
db.AddInParameter(cmd, "@BalanceDays", DbType.Decimal, hRMemberLeaveOpeningBalanceEntity.BalanceDays);
db.AddInParameter(cmd, "@BalanceAsOffDate", DbType.DateTime, hRMemberLeaveOpeningBalanceEntity.BalanceAsOffDate);
db.AddInParameter(cmd, "@Remarks", DbType.String, hRMemberLeaveOpeningBalanceEntity.Remarks);
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 void SaveHRMemberLeaveOpeningBalanceEntity()
{
if (IsValid)
{
try
{
HRMemberLeaveOpeningBalanceEntity hRMemberLeaveOpeningBalanceEntity = BuildHRMemberLeaveOpeningBalanceEntity();
Int64 result = -1;
if (hRMemberLeaveOpeningBalanceEntity.IsNew)
{
result = FCCHRMemberLeaveOpeningBalance.GetFacadeCreate().Add(hRMemberLeaveOpeningBalanceEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(HRMemberLeaveOpeningBalanceEntity.FLD_NAME_MemberLeaveOpeningBalanceID, hRMemberLeaveOpeningBalanceEntity.MemberLeaveOpeningBalanceID.ToString(), SQLMatchType.Equal);
result = FCCHRMemberLeaveOpeningBalance.GetFacadeCreate().Update(hRMemberLeaveOpeningBalanceEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
_MemberLeaveOpeningBalanceID = 0;
_HRMemberLeaveOpeningBalanceEntity = new HRMemberLeaveOpeningBalanceEntity();
PrepareInitialView();
BindHRMemberLeaveOpeningBalanceList();
if (hRMemberLeaveOpeningBalanceEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Member Leave Opening Balance Information has been added successfully.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Member Leave Opening Balance Information has been updated successfully.", false);
}
}
else
{
if (hRMemberLeaveOpeningBalanceEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Member Leave Opening Balance Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Member Leave Opening Balance Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
protected void lvHRMemberLeaveOpeningBalance_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 MemberLeaveOpeningBalanceID;
Int64.TryParse(e.CommandArgument.ToString(), out MemberLeaveOpeningBalanceID);
if (MemberLeaveOpeningBalanceID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
_MemberLeaveOpeningBalanceID = MemberLeaveOpeningBalanceID;
PrepareEditView();
cpeEditor.Collapsed = false;
cpeEditor.ClientState = "false";
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(HRMemberLeaveOpeningBalanceEntity.FLD_NAME_MemberLeaveOpeningBalanceID, MemberLeaveOpeningBalanceID.ToString(), SQLMatchType.Equal);
HRMemberLeaveOpeningBalanceEntity hRMemberLeaveOpeningBalanceEntity = new HRMemberLeaveOpeningBalanceEntity();
result = FCCHRMemberLeaveOpeningBalance.GetFacadeCreate().Delete(hRMemberLeaveOpeningBalanceEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_MemberLeaveOpeningBalanceID = 0;
_HRMemberLeaveOpeningBalanceEntity = new HRMemberLeaveOpeningBalanceEntity();
PrepareInitialView();
BindHRMemberLeaveOpeningBalanceList();
MiscUtil.ShowMessage(lblMessage, "Member Leave Opening Balance has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Member Leave Opening Balance.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
private Int64 DeleteTran(HRMemberLeaveOpeningBalanceEntity hRMemberLeaveOpeningBalanceEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.HRMemberLeaveOpeningBalance_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 HRMemberLeaveOpeningBalanceEntity BuildHRMemberLeaveOpeningBalanceEntity()
{
HRMemberLeaveOpeningBalanceEntity hRMemberLeaveOpeningBalanceEntity = CurrentHRMemberLeaveOpeningBalanceEntity;
if (ddlAttendanceLeaveHolidayListID.Items.Count > 0)
{
if (ddlAttendanceLeaveHolidayListID.SelectedValue == "0")
{
}
else
{
hRMemberLeaveOpeningBalanceEntity.AttendanceLeaveHolidayListID = Int64.Parse(ddlAttendanceLeaveHolidayListID.SelectedValue);
}
}
if (ddlEmployeeID.Items.Count > 0)
{
if (ddlEmployeeID.SelectedValue == "0")
{
}
else
{
hRMemberLeaveOpeningBalanceEntity.EmployeeID = Int64.Parse(ddlEmployeeID.SelectedValue);
}
}
if (!txtBalanceDays.Text.Trim().IsNullOrEmpty())
{
hRMemberLeaveOpeningBalanceEntity.BalanceDays = Decimal.Parse(txtBalanceDays.Text.Trim());
}
else
{
hRMemberLeaveOpeningBalanceEntity.BalanceDays = null;
}
if (txtBalanceAsOffDate.Text.Trim().IsNotNullOrEmpty())
{
hRMemberLeaveOpeningBalanceEntity.BalanceAsOffDate = MiscUtil.ParseToDateTime(txtBalanceAsOffDate.Text);
}
else
{
hRMemberLeaveOpeningBalanceEntity.BalanceAsOffDate = null;
}
hRMemberLeaveOpeningBalanceEntity.Remarks = txtRemarks.Text.Trim();
return(hRMemberLeaveOpeningBalanceEntity);
}
private Int64 Update(HRMemberLeaveOpeningBalanceEntity hRMemberLeaveOpeningBalanceEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.HRMemberLeaveOpeningBalance_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddFilterExpressionParameter(cmd, filterExpression);
Database.AddInParameter(cmd, "@MemberLeaveOpeningBalanceID", DbType.Int64, hRMemberLeaveOpeningBalanceEntity.MemberLeaveOpeningBalanceID);
Database.AddInParameter(cmd, "@AttendanceLeaveHolidayListID", DbType.Int64, hRMemberLeaveOpeningBalanceEntity.AttendanceLeaveHolidayListID);
Database.AddInParameter(cmd, "@EmployeeID", DbType.Int64, hRMemberLeaveOpeningBalanceEntity.EmployeeID);
Database.AddInParameter(cmd, "@BalanceDays", DbType.Decimal, hRMemberLeaveOpeningBalanceEntity.BalanceDays);
Database.AddInParameter(cmd, "@BalanceAsOffDate", DbType.DateTime, hRMemberLeaveOpeningBalanceEntity.BalanceAsOffDate);
Database.AddInParameter(cmd, "@Remarks", DbType.String, hRMemberLeaveOpeningBalanceEntity.Remarks);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("HRMemberLeaveOpeningBalanceEntity already exists. Please specify another HRMemberLeaveOpeningBalanceEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("HRMemberLeaveOpeningBalanceEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("HRMemberLeaveOpeningBalanceEntity already exists. Please specify another HRMemberLeaveOpeningBalanceEntity.");
}
}
}
}
return(returnCode);
}
private Int64 Delete(HRMemberLeaveOpeningBalanceEntity hRMemberLeaveOpeningBalanceEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.HRMemberLeaveOpeningBalance_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("HRMemberLeaveOpeningBalanceEntity already exists. Please specify another HRMemberLeaveOpeningBalanceEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("HRMemberLeaveOpeningBalanceEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("HRMemberLeaveOpeningBalanceEntity already exists. Please specify another HRMemberLeaveOpeningBalanceEntity.");
}
}
}
}
return(returnCode);
}
Int64 IHRMemberLeaveOpeningBalanceFacade.Delete(HRMemberLeaveOpeningBalanceEntity hRMemberLeaveOpeningBalanceEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateHRMemberLeaveOpeningBalanceDataAccess().Delete(hRMemberLeaveOpeningBalanceEntity, filterExpression, option, reqTran));
}
Int64 IHRMemberLeaveOpeningBalanceFacade.Add(HRMemberLeaveOpeningBalanceEntity hRMemberLeaveOpeningBalanceEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateHRMemberLeaveOpeningBalanceDataAccess().Add(hRMemberLeaveOpeningBalanceEntity, option, reqTran));
}
protected void btnAddNew_Click(object sender, EventArgs e)
{
_MemberLeaveOpeningBalanceID = 0;
_HRMemberLeaveOpeningBalanceEntity = new HRMemberLeaveOpeningBalanceEntity();
PrepareInitialView();
}
