private void AddPUCAccDep()
{
if (ValidatePUCAccDep())
{
if (m_objPUCAccount == null)
{
m_objPUCAccount = new PUCAccount();
m_objPUCAccount.LocationCodeId = Convert.ToInt32(cmbLocCode.SelectedValue);
//m_objPUCAccount.PUCLocId = (int)cmbPUC.SelectedValue;
m_objPUCAccount.PCId = (int)cmbPUC.SelectedValue;
m_objPUCAccount.CurrentLocationId = Common.CurrentLocationId;
m_objPUCAccount.CreatedBy = m_userId;
m_objPUCAccount.CreatedDate = Convert.ToDateTime(Common.DATETIME_NULL);
m_objPUCAccount.ModifiedBy = m_userId;
m_objPUCAccount.ModifiedDate = Convert.ToDateTime(Common.DATETIME_NULL);
PUCDeposit objPUCdeposit = new PUCDeposit();
objPUCdeposit.LocationCodeId = m_objPUCAccount.LocationCodeId;
objPUCdeposit.PCId = m_objPUCAccount.PCId;
objPUCdeposit.RecordNo = "-1";
objPUCdeposit.TransactionNo = txtTranNo.Text.Trim();
objPUCdeposit.Date = Convert.ToDateTime(dtpDepositDate.Value.ToString(Common.DATE_TIME_FORMAT));
objPUCdeposit.Amount = Convert.ToDecimal(txtDepositAmount.Text.Trim());
objPUCdeposit.PaymentModeId = Convert.ToInt32(cmbPaymentMode.SelectedValue);
objPUCdeposit.PaymentModeType = ((DataRowView)cmbPaymentMode.SelectedItem)["keyvalue1"].ToString();
objPUCdeposit.CreatedBy = m_userId;
objPUCdeposit.ModifiedBy = m_userId;
m_objPUCAccount.Deposits = new List <PUCDeposit>();
m_objPUCAccount.Deposits.Add(objPUCdeposit);
}
else
{
m_objPUCAccount.ModifiedBy = m_userId;
m_objPUCAccount.ModifiedDate = Convert.ToDateTime(m_objPUCAccount.ModifiedDate.ToString(Common.DATE_TIME_FORMAT));
PUCDeposit objPUCdeposit = new PUCDeposit();
objPUCdeposit.LocationCodeId = m_objPUCAccount.LocationCodeId;
objPUCdeposit.PCId = m_objPUCAccount.PCId;
objPUCdeposit.RecordNo = "-1";
objPUCdeposit.TransactionNo = txtTranNo.Text.Trim();
objPUCdeposit.Date = Convert.ToDateTime(dtpDepositDate.Value.ToString(Common.DATE_TIME_FORMAT));
objPUCdeposit.Amount = Convert.ToDecimal(txtDepositAmount.Text.Trim());
objPUCdeposit.PaymentModeId = Convert.ToInt32(cmbPaymentMode.SelectedValue);
objPUCdeposit.PaymentModeType = ((DataRowView)cmbPaymentMode.SelectedItem)["keyvalue1"].ToString();
objPUCdeposit.CreatedBy = m_userId;
objPUCdeposit.ModifiedBy = m_userId;
m_objPUCAccount.Deposits.Add(objPUCdeposit);
}
m_boolSuspendEventHandler = true;
dgvPUCAccDep.DataSource = null;
m_boolSuspendEventHandler = false;
dgvPUCAccDep.DataSource = m_objPUCAccount.Deposits;
btnSaveDBRecord.Enabled = IsSaveAvailable;
}
}
private void SearchPUCAcc()
{
try
{
if (ValidateSearchCriteria())
{
string errorMessage = "";
int locCode = Common.INT_DBNULL;
int pcId = Common.INT_DBNULL;
string transNo = txtTranNo.Text.Trim();
string date;
if (dtpDepositDate.Checked == true)
{
date = dtpDepositDate.Value.ToString();
}
else
{
date = Common.DATETIME_NULL.ToString();
}
locCode = (int)cmbLocCode.SelectedValue;
if (Convert.ToInt32(cmbPUC.SelectedValue) != Common.INT_DBNULL)
{
pcId = (int)cmbPUC.SelectedValue;
}
PUCCommonTransaction objPUCInfo = new PUCCommonTransaction();
DataTable dtPUCInfo = objPUCInfo.FetchPUCInfo(locCode, pcId, Convert.ToInt32(cmbPaymentMode.SelectedValue), transNo, date, 0, 0, ref errorMessage);
if (string.IsNullOrEmpty(errorMessage))
{
if (dtPUCInfo != null)
{
if (dtPUCInfo.Rows.Count > 0)
{
if (m_objPUCAccount == null)
{
m_objPUCAccount = new PUCAccount();
}
m_lstPUCAccounts = new List <PUCAccount>();
DataTable dtTemp = dtPUCInfo.Copy();
dtPUCInfo.DefaultView.Sort = "PCId,DepositMode";
dtPUCInfo = dtPUCInfo.DefaultView.ToTable();
DataTable dtPUCIds = dtPUCInfo.DefaultView.ToTable(true, "LOCCODE", "LOCCODEID", "PCId", "PUCLocation", "AvailableAmount", "MODIFIEDDATE", "UsedAmount");
DataColumn dcColToAdd = new DataColumn("GridRowNo", typeof(int));
dtPUCIds.Columns.Add(dcColToAdd);
dtPUCIds.AcceptChanges();
int tempRowNo = 0;
foreach (DataRow dtRow in dtPUCIds.Rows)
{
dtRow["GridRowNo"] = tempRowNo++;
}
foreach (DataRow drPCId in dtPUCIds.Rows)
{
m_objPUCAccount = new PUCAccount();
m_objPUCAccount.LocationCodeId = Convert.ToInt32(drPCId["LOCCODEID"]);
m_objPUCAccount.LocationCode = drPCId["LOCCODE"].ToString();
//m_objPUCAccount.PUCLocId = Convert.ToInt32(drPCId["PUCLOCID"]);
m_objPUCAccount.PCId = Convert.ToInt32(drPCId["PCId"]);
m_objPUCAccount.PCLocation = drPCId["PUCLOCATION"].ToString();
m_objPUCAccount.ModifiedDate = Convert.ToDateTime(drPCId["MODIFIEDDATE"].ToString());
m_objPUCAccount.UsedAmount = Math.Round(Convert.ToDecimal(drPCId["UsedAmount"]), Common.DisplayAmountRounding, MidpointRounding.AwayFromZero);
dtPUCInfo.DefaultView.RowFilter = string.Empty;
dtPUCInfo.DefaultView.RowFilter = "PCId = " + m_objPUCAccount.PCId;
DataTable dtPUCInfo_Temp = dtPUCInfo.DefaultView.ToTable();
m_objPUCAccount.Deposits = new List <PUCDeposit>();
foreach (DataRow drPUCInfo in dtPUCInfo_Temp.Rows)
{
PUCDeposit pucaccdeposit = new PUCDeposit();
pucaccdeposit.Amount = Convert.ToDecimal(drPUCInfo["DEPOSITAMOUNT"]);
pucaccdeposit.Date = Convert.ToDateTime(drPUCInfo["DEPOSITDATE"]);
pucaccdeposit.RecordNo = drPUCInfo["RECORDNO"].ToString();
pucaccdeposit.TransactionNo = drPUCInfo["TRANSACTIONNO"].ToString();
pucaccdeposit.PaymentModeId = Convert.ToInt32(drPUCInfo["DEPOSITMODE"]);
pucaccdeposit.PaymentModeType = drPUCInfo["DEPOSITTYPE"].ToString();
m_objPUCAccount.Deposits.Add(pucaccdeposit);
}
m_lstPUCAccounts.Add(m_objPUCAccount);
}
dtPUCInfo.DefaultView.RowFilter = string.Empty;
dtPUCInfo.DefaultView.Sort = string.Empty;
dtPUCInfo = dtTemp.Copy();
dtTemp.Dispose();
dtTemp = null;
System.Globalization.NumberFormatInfo nfi = new System.Globalization.NumberFormatInfo();
nfi.PercentDecimalDigits = Common.DisplayAmountRounding;
string strRoundingZeroesFormat = Common.GetRoundingZeroes(Common.DisplayAmountRounding); //"0.00";
foreach (DataRow drRow in dtPUCInfo.Rows)
{
drRow["AVAILABLEAMOUNT"] = Convert.ToDecimal(drRow["AVAILABLEAMOUNT"]).ToString(strRoundingZeroesFormat, nfi);
drRow["DEPOSITAMOUNT"] = Convert.ToDecimal(drRow["DEPOSITAMOUNT"]).ToString(strRoundingZeroesFormat, nfi);
}
dtPUCInfo.AcceptChanges();
m_boolSuspendEventHandler = true;
dgvPUCAccounts.DataSource = m_lstPUCAccounts;//dtPUCInfo;
m_boolSuspendEventHandler = false;
if (dgvPUCAccounts.Rows.Count > 0)
{
m_uisCurrentState = UIState.ViewAcc;
ReflectPUCAcc(Convert.ToInt32(dgvPUCAccounts.Rows[0].Cells["PCId"].Value.ToString()));
ManageUIState();
}
}
else
{
m_objPUCAccount = null;
MessageBox.Show(Common.GetMessage("8002"), Common.GetMessage("10004"), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
m_objPUCAccount = null;
MessageBox.Show(Common.GetMessage("8002"), Common.GetMessage("10004"), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show(errorMessage, Common.GetMessage("10004"), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show(m_sbErrorMessages.ToString(), Common.GetMessage("10004"), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
}
}
