protected void GetAccReceiptById(int ReceiptID)
{
AccReceiptstbl AR = new AccReceiptstbl
{
ReceiptID = ReceiptID
};
List <AccReceiptstbl> lstAccReceipts = new List <AccReceiptstbl>();
lstAccReceipts = objAccReceiptsBL.GetAccReceiptById(AR).ToList();
foreach (var el in lstAccReceipts)
{
hdnReceiptID.Value = el.ReceiptID.ToString();
lblVNo.Text = el.VoucherNo;
lblMaAcc.Text = GetMajorAccounts(Convert.ToInt32(el.MajorAccount));
lblMiAcc.Text = GetMinorAccounts(Convert.ToInt32(el.MinorAccount));
lblRDate.Text = Convert.ToDateTime(el.ReceiveDate).ToShortDateString();
lblFromAcc.Text = GetAgents(Convert.ToInt32(el.FromAccount));
//lblRFrom.Text = el.ReceivedFrom.ToString();
//lblDTo.Text = el.DepositTo;
//lblRM.Text = el.ReceiptMode;
// Cash
if (Convert.ToInt32(el.ReceivedThrough) == 1)
{
lblReceivedThro.Text = "Cash";
lblChequeNo.Visible = false;
lblCNo.Visible = false;
lblChequeDate.Visible = false;
lblCDate.Visible = false;
lblDDNo.Visible = false;
lblDDN.Visible = false;
lblDDDate.Visible = false;
lblDDD.Visible = false;
lblAccountNo.Visible = false;
lblAcuntNo.Visible = false;
lblBankName.Visible = false;
lblBName.Visible = false;
lblCardNo.Visible = false;
lblCardNumber.Visible = false;
lblTransactionDate.Visible = false;
lblTDate.Visible = false;
lblReferenceNo.Visible = false;
lblRefrnceNo.Visible = false;
lblPaymentMode.Visible = false;
lblPaytMode.Visible = false;
if (Convert.ToInt32(el.ToAccount) == 1)
{
lblToAcct.Text = "Cash in hand";
}
divPM.Visible = false;
divCheque.Visible = false;
divDD.Visible = false;
divBank.Visible = false;
divCard.Visible = false;
divTD.Visible = false;
divRN.Visible = false;
}
// Bank
else if (Convert.ToInt32(el.ReceivedThrough) == 2)
{
divPM.Visible = true;
//divCheque.Visible = false;
//divDD.Visible = false;
//divBank.Visible = false;
//divCard.Visible = false;
//divTD.Visible = false;
//divRN.Visible = false;
lblReceivedThro.Text = "Bank";
lblToAcct.Text = GetBank(Convert.ToInt32(el.ToAccount));
// Cheque
if (Convert.ToInt32(el.PaymentMode) == 1)
{
divCheque.Visible = true;
divDD.Visible = false;
divBank.Visible = true;
divCard.Visible = false;
divTD.Visible = false;
divRN.Visible = false;
lblPaytMode.Text = "Cheque";
lblDDNo.Visible = false;
lblDDN.Visible = false;
lblDDDate.Visible = false;
lblDDD.Visible = false;
lblCardNo.Visible = false;
lblCardNumber.Visible = false;
lblTransactionDate.Visible = false;
lblTDate.Visible = false;
lblReferenceNo.Visible = false;
lblRefrnceNo.Visible = false;
}
// DD
else if (Convert.ToInt32(el.PaymentMode) == 2)
{
divPM.Visible = true;
divCheque.Visible = false;
divDD.Visible = true;
divBank.Visible = true;
divCard.Visible = false;
divTD.Visible = false;
divRN.Visible = false;
lblPaytMode.Text = "DD";
lblChequeNo.Visible = false;
lblCNo.Visible = false;
lblChequeDate.Visible = false;
lblCDate.Visible = false;
lblCardNo.Visible = false;
lblCardNumber.Visible = false;
lblTransactionDate.Visible = false;
lblTDate.Visible = false;
lblReferenceNo.Visible = false;
lblRefrnceNo.Visible = false;
}
// Credit/ Debit Card
else if (Convert.ToInt32(el.PaymentMode) == 3)
{
divPM.Visible = true;
divCheque.Visible = false;
divDD.Visible = false;
divBank.Visible = false;
divCard.Visible = true;
divTD.Visible = true;
divRN.Visible = true;
lblPaytMode.Text = "Credit/Debit card";
lblChequeNo.Visible = false;
lblCNo.Visible = false;
lblChequeDate.Visible = false;
lblCDate.Visible = false;
lblDDNo.Visible = false;
lblDDN.Visible = false;
lblDDDate.Visible = false;
lblDDD.Visible = false;
lblAccountNo.Visible = false;
lblAcuntNo.Visible = false;
lblBankName.Visible = false;
lblBName.Visible = false;
}
// Internet Banking
else if (Convert.ToInt32(el.PaymentMode) == 4)
{
divPM.Visible = true;
divCheque.Visible = false;
divDD.Visible = false;
divBank.Visible = false;
divCard.Visible = false;
divTD.Visible = true;
divRN.Visible = true;
lblPaytMode.Text = "InternetBanking";
lblChequeNo.Visible = false;
lblCNo.Visible = false;
lblChequeDate.Visible = false;
lblCDate.Visible = false;
lblDDNo.Visible = false;
lblDDN.Visible = false;
lblDDDate.Visible = false;
lblDDD.Visible = false;
lblAccountNo.Visible = false;
lblAcuntNo.Visible = false;
lblBankName.Visible = false;
lblBName.Visible = false;
lblCardNo.Visible = false;
lblCardNumber.Visible = false;
}
}
lblCBalance.Text = el.CurrentBalance;
lblReceivingAmt.Text = el.ReceivingAmount;
//lblPaymentMode.Text = el.PaymentMode;
lblCNo.Text = el.ChequeNo.ToString();
lblCDate.Text = Convert.ToDateTime(el.ChequeDate).ToShortDateString();
lblDDN.Text = el.DDNO.ToString();
lblDDD.Text = Convert.ToDateTime(el.Date).ToShortDateString();
lblAcuntNo.Text = el.AccountNO;
lblBName.Text = el.BankName;
lblCardNumber.Text = el.CardNo;
lblTDate.Text = el.TransactionDate == "" ? "" : Convert.ToDateTime(el.TransactionDate).ToShortDateString();
//Convert.ToDateTime(el.TransactionDate).ToShortDateString();
lblRefrnceNo.Text = el.ReferenceNo;
//lblCmnt.Text = el.Comment;
lblNrtn.Text = el.Narration;
lblFN.Text = el.AttachFiles;
LiteralControl lc = new LiteralControl();
lc.Text = "<a href='../Files/Payments/" + el.AttachFiles + "' class='btn btn-success btn-file' download><i class='fa fa-download'></i></a>";
PlaceHolder1.Controls.Add(lc);
//GetBank();
}
}
public IEnumerable <AccReceiptstbl> UpdateAccReceiptStatus(AccReceiptstbl ls)
{
return(objAccReceiptsDA.AccReceiptsAll(7, ls));
}
public IEnumerable <AccReceiptstbl> GetAccReceiptByStatus(AccReceiptstbl ls)
{
return(objAccReceiptsDA.AccReceiptsAll(8, ls));
}
public IEnumerable <AccReceiptstbl> DeleteAccReceipt(AccReceiptstbl ls)
{
return(objAccReceiptsDA.AccReceiptsAll(5, ls));
}
public IEnumerable <AccReceiptstbl> UpdateAccReceiptIsActive(AccReceiptstbl ls)
{
return(objAccReceiptsDA.AccReceiptsAll(6, ls));
}
public IEnumerable <AccReceiptstbl> SaveAccReceipt(AccReceiptstbl ls)
{
return(objAccReceiptsDA.AccReceiptsAll(3, ls));
}
public IEnumerable <AccReceiptstbl> GetAccReceiptById(AccReceiptstbl ls)
{
return(objAccReceiptsDA.AccReceiptsAll(2, ls));
}
public IEnumerable <AccReceiptstbl> GetAllAccReceipt(AccReceiptstbl ls)
{
return(objAccReceiptsDA.AccReceiptsAll(1, ls));
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
AccReceiptstbl AR = new AccReceiptstbl();
AR.ReceiptID = Convert.ToInt32(hdnReceiptID.Value);
AR.VoucherNo = txtVNo.Text;
AR.MajorAccount = ddlMAccountList.SelectedValue;
AR.MinorAccount = ddlMinorAccountList.SelectedValue;
AR.ReceiveDate = Convert.ToDateTime(txtRDate.Text).ToString("yyyy-MM-dd");
AR.FromAccount = ddlFromAccount.SelectedValue;
AR.ReceivedThrough = ddlReceivedThrough.SelectedValue;
AR.ToAccount = ddlToAccount.SelectedValue;
AR.CurrentBalance = txtCB.Text;
AR.ReceivingAmount = txtReceivingAmount.Text;
AR.PaymentMode = ddlPaymentMode.SelectedValue;
//Pa.PaymentMode = ddlPaymentMode.SelectedValue;
if (Convert.ToInt32(ddlPaymentMode.SelectedValue) == 1)
{
AR.ChequeNo = string.IsNullOrEmpty(txtCheckNo.Text) ? 0 : Convert.ToInt32(txtCheckNo.Text);
AR.ChequeDate = Convert.ToDateTime(txtChequeDate.Text).ToString("yyyy-MM-dd");
AR.AccountNO = txtAcNo.Text;
AR.BankName = txtBankName.Text;
}
else if (Convert.ToInt32(ddlPaymentMode.SelectedValue) == 2)
{
AR.DDNO = string.IsNullOrEmpty(txtDDNo.Text) ? 0 : Convert.ToInt32(txtDDNo.Text);
AR.Date = Convert.ToDateTime(txtDDDate.Text).ToString("yyyy-MM-dd");
AR.AccountNO = txtAcNo.Text;
AR.BankName = txtBankName.Text;
}
else if (Convert.ToInt32(ddlPaymentMode.SelectedValue) == 3)
{
AR.CardNo = txtCardNo.Text;
AR.TransactionDate = Convert.ToDateTime(txtTDate.Text).ToString("yyyy-MM-dd");
AR.ReferenceNo = txtReferenceNo.Text;
}
else if (Convert.ToInt32(ddlPaymentMode.SelectedValue) == 4)
{
AR.TransactionDate = Convert.ToDateTime(txtTDate.Text).ToString("yyyy-MM-dd");
AR.ReferenceNo = txtReferenceNo.Text;
}
//AR.ChequeNo = string.IsNullOrEmpty(txtCheckNo.Text) ? 0 : Convert.ToInt32(txtCheckNo.Text);
////string.IsNullOrEmpty(txtCheckNo.Text) ? 0 : Convert.ToInt32(txtCheckNo.Text);
//AR.ChequeDate = Convert.ToDateTime(txtChequeDate.Text).ToString("yyyy-MM-dd");
//AR.DDNO = string.IsNullOrEmpty(txtDDNo.Text) ? 0 : Convert.ToInt32(txtDDNo.Text);
////string.IsNullOrEmpty(txtDDNo.Text) ? 0 : Convert.ToInt32(txtDDNo.Text);
//AR.Date = Convert.ToDateTime(txtDDDate.Text).ToString("yyyy-MM-dd");
//AR.AccountNO = txtAcNo.Text;
//AR.BankName = txtBankName.Text;
//AR.CardNo = txtCardNo.Text;
//AR.TransactionDate = Convert.ToDateTime(txtTDate.Text).ToString("yyyy-MM-dd");
//AR.ReferenceNo = txtReferenceNo.Text;
//AR.Comment = txtComments.Text;
AR.Narration = txtNrtn.Text;
AR.AttachFiles = UploadDoc.FileName;
List <AccReceiptstbl> lst = new List <AccReceiptstbl>();
AR.IsActive = 1;
AR.UpdatedBy = 1;
AR.UpdatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
objAccReceiptsBL.UpdateAccReceipt(AR).ToList();
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "alertMessage('AccountReceipts Updated Successfully');", true);
Clear();
//UploadFile();
if (UploadDoc.HasFile == false)
{
}
else
{
UploadFile();
}
}
protected void GetAccReceiptById(int ReceiptID)
{
AccReceiptstbl AR = new AccReceiptstbl
{
ReceiptID = ReceiptID
};
List <AccReceiptstbl> lstAccReceipt = new List <AccReceiptstbl>();
lstAccReceipt = objAccReceiptsBL.GetAccReceiptById(AR).ToList();
foreach (var el in lstAccReceipt)
{
hdnReceiptID.Value = el.ReceiptID.ToString();
txtVNo.Text = el.VoucherNo;
GetMajorAccounts(Convert.ToInt32(el.MajorAccount));
ddlMAccountList.SelectedValue = el.MajorAccount;
GetMinorAccounts(Convert.ToInt32(el.MinorAccount));
ddlMinorAccountList.SelectedValue = el.MinorAccount;
txtRDate.Text = Convert.ToDateTime(el.ReceiveDate).ToShortDateString();
GetAgents(Convert.ToInt32(el.FromAccount));
ddlFromAccount.SelectedValue = el.FromAccount;
//ddlDepositTo.SelectedValue = el.DepositTo;
// Cash
if (Convert.ToInt32(el.ReceivedThrough) == 1)
{
divPM.Visible = false;
divCheque.Visible = false;
divDD.Visible = false;
divBank.Visible = false;
divCard.Visible = false;
divTD.Visible = false;
divRN.Visible = false;
ddlReceivedThrough.SelectedValue = 1.ToString();
lblChequeNo.Visible = false;
txtCheckNo.Visible = false;
lblChequeDate.Visible = false;
txtChequeDate.Visible = false;
lblDDNo.Visible = false;
txtDDNo.Visible = false;
lblDDDate.Visible = false;
txtDDDate.Visible = false;
lblAccountNo.Visible = false;
txtAcNo.Visible = false;
lblBankName.Visible = false;
txtBankName.Visible = false;
lblCardNo.Visible = false;
txtCardNo.Visible = false;
lblTransactionDate.Visible = false;
txtTDate.Visible = false;
lblReferenceNo.Visible = false;
txtReferenceNo.Visible = false;
lblPaymentMode.Visible = false;
ddlPaymentMode.Visible = false;
ddlToAccount.Items.Clear();
ddlToAccount.Items.Add(new ListItem("--Select--"));
ddlToAccount.Items.Add(new ListItem("Cash in hand", "1"));
ddlToAccount.SelectedValue = 1.ToString();
//divPM.Visible = false;
}
// Bank
else if (Convert.ToInt32(el.ReceivedThrough) == 2)
{
divPM.Visible = true;
ddlReceivedThrough.SelectedValue = 2.ToString();
ddlToAccount.Items.Clear();
//ddlReceiptMode.Items.Add(new ListItem("--Select--"));
//ddlReceiptMode.Items.Add(new ListItem("Axis Bank", "2"));
//ddlReceiptMode.Items.Add(new ListItem("HDFC Bank", "3"));
//ddlReceiptMode.Items.Add(new ListItem("SBI Bank", "4"));
//ddlReceiptMode.Items.Add(new ListItem("ICICI Bank", "5"));
GetBank();
//divPM.Visible = true;
ddlToAccount.SelectedValue = el.ToAccount;
// Cheque
if (Convert.ToInt32(el.PaymentMode) == 1)
{
divPM.Visible = true;
divCheque.Visible = true;
divDD.Visible = false;
divBank.Visible = true;
divCard.Visible = false;
divTD.Visible = false;
divRN.Visible = false;
lblDDNo.Visible = false;
txtDDNo.Visible = false;
lblDDDate.Visible = false;
txtDDDate.Visible = false;
lblCardNo.Visible = false;
txtCardNo.Visible = false;
lblTransactionDate.Visible = false;
txtTDate.Visible = false;
lblReferenceNo.Visible = false;
txtReferenceNo.Visible = false;
txtCheckNo.Text = el.ChequeNo.ToString();
txtChequeDate.Text = Convert.ToDateTime(el.ChequeDate).ToShortDateString();
}
// DD
else if (Convert.ToInt32(el.PaymentMode) == 2)
{
divPM.Visible = true;
divCheque.Visible = false;
divDD.Visible = true;
divBank.Visible = true;
divCard.Visible = false;
divTD.Visible = false;
divRN.Visible = false;
lblChequeNo.Visible = false;
txtCheckNo.Visible = false;
lblChequeDate.Visible = false;
txtChequeDate.Visible = false;
lblCardNo.Visible = false;
txtCardNo.Visible = false;
lblTransactionDate.Visible = false;
txtTDate.Visible = false;
lblReferenceNo.Visible = false;
txtReferenceNo.Visible = false;
txtDDNo.Text = el.DDNO.ToString();
txtDDDate.Text = Convert.ToDateTime(el.Date).ToShortDateString();
}
// Credit/ Debit Card
else if (Convert.ToInt32(el.PaymentMode) == 3)
{
divPM.Visible = true;
divCheque.Visible = false;
divDD.Visible = false;
divBank.Visible = false;
divCard.Visible = true;
divTD.Visible = true;
divRN.Visible = true;
lblChequeNo.Visible = false;
txtCheckNo.Visible = false;
lblChequeDate.Visible = false;
txtChequeDate.Visible = false;
lblDDNo.Visible = false;
txtDDNo.Visible = false;
lblDDDate.Visible = false;
txtDDDate.Visible = false;
lblAccountNo.Visible = false;
txtAcNo.Visible = false;
lblBankName.Visible = false;
txtBankName.Visible = false;
}
// Internet Banking
else if (Convert.ToInt32(el.PaymentMode) == 4)
{
divPM.Visible = true;
divCheque.Visible = false;
divDD.Visible = false;
divBank.Visible = false;
divCard.Visible = false;
divTD.Visible = true;
divRN.Visible = true;
lblChequeNo.Visible = false;
txtCheckNo.Visible = false;
lblChequeDate.Visible = false;
txtChequeDate.Visible = false;
lblDDNo.Visible = false;
txtDDNo.Visible = false;
lblDDDate.Visible = false;
txtDDDate.Visible = false;
lblAccountNo.Visible = false;
txtAcNo.Visible = false;
lblBankName.Visible = false;
txtBankName.Visible = false;
lblCardNo.Visible = false;
txtCardNo.Visible = false;
}
}
//ddlReceiptMode.SelectedValue = el.ReceiptMode;
txtCB.Text = el.CurrentBalance;
txtReceivingAmount.Text = el.ReceivingAmount;
ddlPaymentMode.SelectedValue = el.PaymentMode;
txtAcNo.Text = el.AccountNO;
txtBankName.Text = el.BankName;
txtCardNo.Text = el.CardNo;
txtTDate.Text = el.TransactionDate == "" ? "" : Convert.ToDateTime(el.TransactionDate).ToShortDateString();
txtReferenceNo.Text = el.ReferenceNo;
//txtComments.Text = el.Comment;
txtNrtn.Text = el.Narration;
lblChooseF.Text = el.AttachFiles;
//GetAgents();
}
}
