public static void CreatePayment(clsPaymentInfo pay)
{
string connectionString = DataManager.OraConnString();
SqlConnection sqlCon = new SqlConnection(connectionString);
string query = "insert into payment_info (pay_id, pay_head_id,pay_type,pay_class,for_all_std,pay_amt,discount,version,GroupID) values ( '" + pay.PayId + "', '" + pay.PayName + "', '" + pay.PayType + "',convert(numeric,nullif('" + pay.PayClass + "','')),'" + pay.ForAllStd + "', convert(decimal(13,2),nullif('" + pay.PayAmt + "','')),'" + pay.Discount + "','" + pay.Version + "','" + pay.GroupID + "')";
DataManager.ExecuteNonQuery(connectionString, query);
}
public static void UpdatePayment(clsPaymentInfo pay)
{
string connectionString = DataManager.OraConnString();
SqlConnection sqlCon = new SqlConnection(connectionString);
string query = "update payment_info set pay_head_id='" + pay.PayName + "',pay_type='" + pay.PayType + "',pay_class=convert(numeric,nullif('" + pay.PayClass + "','')),for_all_std='" + pay.ForAllStd + "' ,pay_amt=convert(decimal(13,2),nullif('" + pay.PayAmt + "','')), discount='" + pay.Discount + "',version='" + pay.Version + "',GroupID='" + pay.GroupID + "' where pay_id='" + pay.PayId + "'";
DataManager.ExecuteNonQuery(connectionString, query);
}
private void AddPaymentsReceivedItemToGrid(clsPaymentInfo payment)
{
int rowidx = dgvPayments.Rows.Add();
dgvPayments.Rows[rowidx].Cells[0].Value = payment.Timestamp;
dgvPayments.Rows[rowidx].Cells[1].Value = payment.AccountName;
dgvPayments.Rows[rowidx].Cells[2].Value = payment.AmountPaid;
dgvPayments.Rows[rowidx].Cells[3].Value = payment.UserName;
}
private void AddItemToGrid(clsPaymentInfo fitem)
{
int rowidx = dgvPayments.Rows.Add();
dgvPayments.Rows[rowidx].Cells[0].Value = fitem.Timestamp;
dgvPayments.Rows[rowidx].Cells[1].Value = fitem.AccountName;
dgvPayments.Rows[rowidx].Cells[2].Value = fitem.AmountPaid;
dgvPayments.Rows[rowidx].Cells[3].Value = fitem.Remarks;
dgvPayments.Rows[rowidx].Cells[4].Value = fitem.UserName;
}
protected void dgPay_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
if (per.AllowEdit == "Y")
{
clsPaymentInfo pay = clsPaymentInfoManager.getPayment(((TextBox)dgPay.Rows[e.RowIndex].FindControl("txtPayId")).Text);
if (pay != null)
{
pay.PayName = ((DropDownList)dgPay.Rows[e.RowIndex].FindControl("ddlPayHead")).SelectedValue.Trim();
pay.PayType = ((DropDownList)dgPay.Rows[e.RowIndex].FindControl("ddlPayType")).SelectedValue.Trim();
pay.ForAllStd = ((DropDownList)dgPay.Rows[e.RowIndex].FindControl("ddlForAllStd")).SelectedValue.Trim();
pay.PayClass = ((DropDownList)dgPay.Rows[e.RowIndex].FindControl("ddlPayClass")).SelectedValue.Trim();
pay.Discount = ((DropDownList)dgPay.Rows[e.RowIndex].FindControl("ddlDiscount")).SelectedValue.Trim();
pay.PayAmt = ((TextBox)dgPay.Rows[e.RowIndex].FindControl("txtPayAmt")).Text;
pay.Version = ((DropDownList)dgPay.Rows[e.RowIndex].FindControl("ddlVersion")).SelectedValue.Trim();
pay.GroupID = ((DropDownList)dgPay.Rows[e.RowIndex].FindControl("ddlGroup")).SelectedValue.Trim();
clsPaymentInfoManager.UpdatePayment(pay);
}
DataTable dt = (DataTable)Session["Payment"];
if (dt.Rows.Count > 0)
{
dgPay.DataSource = dt;
dgPay.EditIndex = -1;
dgPay.DataBind();
}
else
{
getEmptyGrid();
}
ClientScript.RegisterStartupScript(this.GetType(), "ale", "alert('Record udpated successfully!!');", true);
}
}
catch (FormatException fex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('" + fex.Message + "');", true);
}
catch (Exception ex)
{
if (ex.Message.Contains("Database"))
{
ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('Database Maintain Error. Contact to the Software Provider..!!');", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('There is some problem to do the task. Try again properly.!!');", true);
}
}
}
protected void dgPay_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "AddNew")
{
//DataTable dt = clsPaymentInfoManager.GetPayments();
DataTable dt = (DataTable)Session["Payment"];
dgPay.DataSource = dt;
dgPay.DataBind();
dgPay.ShowFooter = true;
dgPay.FooterRow.Visible = true;
((TextBox)dgPay.FooterRow.FindControl("txtPayId")).Text = IdManager.GetNextID("payment_info", "Pay_id").ToString();
//((TextBox)dgPay.FooterRow.FindControl("txtPayName")).Focus();
((TextBox)dgPay.FooterRow.FindControl("txtPayAmt")).Text = "0";
((DropDownList)dgPay.FooterRow.FindControl("ddlPayClass")).Items.Clear();
string queryDist = "select class_id,class_name from class_info order by 1";
util.PopulationDropDownList(((DropDownList)dgPay.FooterRow.FindControl("ddlPayClass")), "Class", queryDist, "class_name", "class_id");
((DropDownList)dgPay.FooterRow.FindControl("ddlPayClass")).Items.Insert(0, "");
((DropDownList)dgPay.FooterRow.FindControl("ddlVersion")).Items.Clear();
//string queryVersion = "select '' id, 'Select Version' version_name union select id,version_name from version_info order by 1";
//util.PopulationDropDownList(((DropDownList)dgPay.FooterRow.FindControl("ddlVersion")), "Verson", queryVersion, "version_name", "id");
string queryHead = "select '' id, 'Select Head' Head_Name union select id,Head_Name from payment_head order by 1";
util.PopulationDropDownList(((DropDownList)dgPay.FooterRow.FindControl("ddlPayHead")), "PayHead", queryHead, "Head_Name", "id");
}
else if (e.CommandName == "Insert")
{
clsPaymentInfo pay = new clsPaymentInfo();
pay.PayId = ((TextBox)dgPay.FooterRow.FindControl("txtPayId")).Text.Trim();
pay.PayName = ((DropDownList)dgPay.FooterRow.FindControl("ddlPayHead")).SelectedValue.Trim();
pay.PayType = ((DropDownList)dgPay.FooterRow.FindControl("ddlPayType")).SelectedValue.Trim();
pay.PayClass = ((DropDownList)dgPay.FooterRow.FindControl("ddlPayClass")).SelectedValue.Trim();
pay.ForAllStd = ((DropDownList)dgPay.FooterRow.FindControl("ddlForAllStd")).SelectedValue.Trim();
pay.PayAmt = ((TextBox)dgPay.FooterRow.FindControl("txtPayAmt")).Text.Trim();
pay.Discount = ((DropDownList)dgPay.FooterRow.FindControl("ddlDiscount")).SelectedValue.Trim();
pay.Version = ((DropDownList)dgPay.FooterRow.FindControl("ddlVersion")).SelectedValue.Trim();
pay.GroupID = ((DropDownList)dgPay.FooterRow.FindControl("ddlGroup")).SelectedValue.Trim();
if (per.AllowAdd == "Y")
{
clsPaymentInfoManager.CreatePayment(pay);
}
//DataTable dt = clsPaymentInfoManager.GetPayments();
DataTable dt = (DataTable)Session["Payment"];
if (dt.Rows.Count > 0)
{
dgPay.DataSource = dt;
dgPay.EditIndex = -1;
dgPay.DataBind();
dgPay.FooterRow.Visible = false;
dgPay.ShowFooter = false;
}
else
{
getEmptyGrid();
}
ClientScript.RegisterStartupScript(this.GetType(), "ale", "alert('Record created successfully!!');", true);
}
}
catch (FormatException fex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('" + fex.Message + "');", true);
}
catch (Exception ex)
{
if (ex.Message.Contains("Database"))
{
ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('Database Maintain Error. Contact to the Software Provider..!!');", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('There is some problem to do the task. Try again properly.!!');", true);
}
}
}
private bool CancelPayment()
{
if (!clsUtil.GetApproval(m_user, UserAccess.Manager))
{
return(false);
}
frmSelectAccounts acct = new frmSelectAccounts(0, m_user);
if (acct.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
clsAccountInfo a = acct.SelectedAccount;
frmInput input = new frmInput();
input.Title = "Retrieve Payment Info";
input.Caption = "Payment Reference";
input.IsHiddenInput = false;
input.IsNumericOnly = true;
input.withDecimal = false;
input.Value = "";
if (input.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
clsPaymentInfo payment = clsPaymentInfo.GetPayment(Convert.ToInt32(input.Value));
if (payment != null)
{
clsChargedTransaction charges = clsChargedTransaction.GetChargedTransaction(payment.OrNum);
if (charges != null && payment.PaymentId != 0 && payment.AccountId == a.AccountId)
{
if (payment.Remarks.ToLower().Contains("interest"))
{
MessageBox.Show("Interest payment cancellation not allowed!", "Cancel Payment", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else if (MessageBox.Show(string.Format("Are you sure you want to cancel payment?\nRefno:{0}\nRemarks:{1}\nAmount:P {2:0.00}", payment.PaymentId, payment.Remarks, payment.AmountPaid), "Cancel Payment", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
if (payment.Remarks.ToLower().Contains("principal"))
{
a.PrincipalBalance += payment.AmountPaid;
a.Save();
charges.TransBalance += payment.AmountPaid;
charges.SaveChargeTransaction();
if (clsPaymentInfo.CancelPayment(payment.PaymentId))
{
MessageBox.Show("Payment successfully cancelled!", "Cancel Payment", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Cancel Payment did not succeed!", "Cancel Payment", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
}
}
}
else
{
MessageBox.Show("Payment Reference not found under this account", "Cancel Payment", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
return(false);
}
private void btnPayment_Click(object sender, EventArgs e)
{
if (dgvAccounts.SelectedRows.Count > 0)
{
if (m_Accounts != null)
{
foreach (clsAccountInfo a in m_Accounts)
{
if (a.AccountName == dgvAccounts.SelectedRows[0].Cells[1].Value.ToString())
{
frmInput payment = new frmInput();
double amountpaid = a.AccountReceivable;
double change = 0;
payment.Title = "Cash Payment";
payment.Caption = "Amount";
payment.IsNumericOnly = true;
payment.Value = a.AccountReceivable.ToString();
if (payment.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
if (Convert.ToDouble(payment.Value) < a.AccountReceivable)
{
amountpaid = Convert.ToDouble(payment.Value);
}
else
{
amountpaid = a.AccountReceivable;
change = Convert.ToDouble(payment.Value) - a.AccountReceivable;
}
if (amountpaid > 0)
{
clsPaymentInfo pay = new clsPaymentInfo();
pay.AccountId = a.AccountId;
pay.AmountPaid = amountpaid;
pay.Timestamp = DateTime.Now;
pay.UserId = m_user.UserId;
pay.UserName = m_user.UserName;
string reference = pay.Save();
string ret = "";
Receipt or = new Receipt();
or.InitializePrinter();
List <string> strmsg = new List <string>();
ret += or.PrintCompanyHeader();
strmsg.Add("");
strmsg.Add("PAYMENT");
ret += or.PrintHeader(strmsg, PrintFontAlignment.Center, PrintFontSize.UnderlineBold);
strmsg.Clear();
strmsg.Add(string.Format("Cashier: {0}", m_user.UserName.ToUpper()));
strmsg.Add(string.Format("Date: {0}", pay.Timestamp.ToString("yyyy-MM-dd HH:mm:ss")));
strmsg.Add(reference);
strmsg.Add(string.Format("Account Name: {0}", a.AccountName));
strmsg.Add(string.Format("Previous Balance: {0}", a.AccountReceivable));
strmsg.Add(string.Format("Amount Paid: {0}", amountpaid));
strmsg.Add(string.Format("Current Balance: {0}", a.AccountReceivable - amountpaid));
a.LoadTransInfo();
//a.PrincipalBalance = clsChargedTransaction.GetPrincipalAmount(a.AccountId);
// a.TotalInterest = clsChargedTransaction.GetTotalInterest(a.AccountId);
a.LastComputedInterest = DateTime.Today;
a.Save();
ret += or.PrintAppend(strmsg, PrintFontAlignment.Left, PrintFontSize.Regular);
or.FormFeed();
or.OpenDrawer();
or.ExecPrint(ret);
strmsg.Clear();
CloseDrawer drawer = new CloseDrawer();
drawer.Change = change;
drawer.ShowDialog();
DisplayAccounts(txtSearch.Text);
}
}
}
}
}
}
}