private PUCAccount InitializePUCObject(int pcId) { PUCAccount objPUCinfo = null; foreach (PUCAccount pacc in m_lstPUCAccounts) { if (pacc.PCId == pcId) { objPUCinfo = new PUCAccount(); objPUCinfo.LocationCodeId = pacc.LocationCodeId; //objPUCinfo.PUCLocId = pacc.PUCLocId == pacc.LocationCodeId ? Common.INT_DBNULL : pacc.PUCLocId; objPUCinfo.PCLocation = pacc.PCLocation; objPUCinfo.PCId = pacc.PCId; objPUCinfo.ModifiedDate = pacc.ModifiedDate; objPUCinfo.Deposits = new List <PUCDeposit>(); foreach (PUCDeposit pdep in pacc.Deposits) { objPUCinfo.Deposits.Add(pdep); } break; } } var query = from a in objPUCinfo.Deposits orderby a.Date select a; objPUCinfo.Deposits = (List <PUCDeposit>)query.ToList(); return(objPUCinfo); }
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 ReflectPUCAcc(int pcId) { m_objPUCAccount = InitializePUCObject(pcId); m_boolSuspendEventHandler = true; dgvPUCAccDep.DataSource = null; m_boolSuspendEventHandler = false; dgvPUCAccDep.DataSource = m_objPUCAccount.Deposits; }
private void btnResetUI_Click(object sender, EventArgs e) { try { //DialogResult resetresult = MessageBox.Show(Common.GetMessage("5006"), Common.GetMessage("10004"), MessageBoxButtons.YesNo, MessageBoxIcon.Question); //if (resetresult == DialogResult.Yes) { ResetUI(); m_objPUCAccount = null; m_lstPUCAccounts = null; } } catch (Exception ex) { Common.LogException(ex); MessageBox.Show(Common.GetMessage("10002"), Common.GetMessage("10004"), MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private PUCAccount InitializePUCObject(DataGridView dgvSender) { PUCAccount objPUCinfo = null; if (dgvSender.SelectedCells.Count > 0) { int pcId = Convert.ToInt32(dgvSender.SelectedRows[0].Cells["PCId"].Value); string recordNo = dgvSender.SelectedRows[0].Cells["RecordNo"].Value.ToString(); foreach (PUCAccount pacc in m_lstPUCAccounts) { if (pacc.PCId == pcId) { objPUCinfo = new PUCAccount(); objPUCinfo.LocationCodeId = pacc.LocationCodeId; objPUCinfo.LocationCode = pacc.LocationCode; //objPUCinfo.PUCLocId = pacc.PUCLocId; objPUCinfo.PCLocation = pacc.PCLocation; objPUCinfo.PCId = pacc.PCId; foreach (PUCDeposit pdep in pacc.Deposits) { if (pdep.RecordNo == recordNo) { objPUCinfo.Deposits = new List <PUCDeposit>(); objPUCinfo.Deposits.Add(pdep); break; } } break; } } if (objPUCinfo != null) { if (objPUCinfo.Deposits == null) { objPUCinfo = null; } } } return(objPUCinfo); }
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) { } }
private void dgvPUCAccDep_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { DataGridView dgvSender = (DataGridView)sender; if ((e.RowIndex > Common.INT_DBNULL) && (e.ColumnIndex > Common.INT_DBNULL)) { string errMsg = string.Empty; switch (dgvSender.Columns[e.ColumnIndex].Name) { case CON_GRIDCOL_EDIT: { ///TODO: EDIT MODE; ///UNCOMMENT THE FOLLOWING COMMENTED-CODE ////Check for RecordNo of the Deposit-Record ////If the Deposit-Record has not yet been saved in DB, ////then RecordNo would be either empty or '-1' //string recordNo = m_objPUCAccount.Deposits[e.RowIndex].RecordNo.Trim(); //if (string.IsNullOrEmpty(recordNo) || recordNo == "-1") //{ // m_uisCurrentState = UIState.AddAccDep; // ManageUIState(); //} //else //{ // errMsg = Common.GetMessage("VAL0108", "edit", "saved Deposit-Entry"); //} } break; case CON_GRIDCOL_REMOVE: { //Check for RecordNo of the Deposit-Record //If the Deposit-Record has not yet been saved in DB, //then RecordNo would be either empty or '-1' string recordNo = m_objPUCAccount.Deposits[e.RowIndex].RecordNo.Trim(); if (string.IsNullOrEmpty(recordNo) || recordNo == "-1") { DialogResult confirmresult = MessageBox.Show(Common.GetMessage("5012"), Common.GetMessage("10004"), MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (confirmresult == DialogResult.Yes) { m_objPUCAccount.Deposits.Remove(m_objPUCAccount.Deposits[e.RowIndex]); m_boolSuspendEventHandler = true; dgvSender.DataSource = null; m_boolSuspendEventHandler = false; if (m_objPUCAccount.Deposits.Count > 0) { m_uisCurrentState = UIState.ViewAcc; dgvSender.DataSource = m_objPUCAccount.Deposits; ManageUIState(); btnSaveDBRecord.Enabled = IsSaveAvailable; } else { m_objPUCAccount = null; m_uisCurrentState = UIState.ResetAcc; ResetPUCAccDep(); ManageUIState(); btnSaveDBRecord.Enabled = false; } } } else { errMsg = Common.GetMessage("VAL0108", "remove", "saved Deposit-Entry"); } } break; } if (!string.IsNullOrEmpty(errMsg)) { MessageBox.Show(errMsg, Common.GetMessage("10004"), MessageBoxButtons.OK, MessageBoxIcon.Error); } } } catch (Exception ex) { Common.LogException(ex); MessageBox.Show(Common.GetMessage("10002"), Common.GetMessage("10004"), MessageBoxButtons.OK, MessageBoxIcon.Error); } }