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