protected void btnpayupdate_Click(object sender, EventArgs e) { if (Page.IsValid) { paymentManager objpay = new paymentManager(); objpay.paymentid = Convert.ToInt32(hidPaymentId.Value); objpay.orderid = Convert.ToInt32(txtPopOrderno.Text.Trim()); objpay.payammount = Convert.ToDecimal(txtPopAmmount.Text.Trim()); objpay.paynotes = Convert.ToString(txtPopNots.Text.Trim()); objpay.paystatus = Convert.ToInt32(1); if (hidCustid.Value != "0") { objpay.customerid = Convert.ToInt32(hidCustid.Value); } else { objpay.contactName = Convert.ToString(txtPOPCustomer.Text); int Custid = objpay.GetCustomerIdByCustomerName(); objpay.customerid = Convert.ToInt32(Custid); } objpay.UpdatePayment(); BindPayment(); } }
protected void imgbtnDelete_Click(object sender, EventArgs e) { if (Page.IsValid) { paymentManager objpay = new paymentManager(); try { int con = 0; CheckBox chk = new CheckBox(); for (int i = 0; i < gvAdmin.Rows.Count; i++) { chk = (CheckBox)(gvAdmin.Rows[i].FindControl("chkDelete")); if (chk.Checked == true) { con += 1; objpay.paymentid = Convert.ToInt32(gvAdmin.DataKeys[gvAdmin.Rows[i].RowIndex].Value.ToString()); objpay.DeletePaymentRecord(); } } BindPayment(); lblmsg.Visible = true; lblmsgs.Text = "Payment details deleted successfully"; } catch (Exception ex) { throw ex; } finally { objpay = null; } } }
public List <string> SearchKeywordPayment(string SearchKey) { paymentManager objpay = new paymentManager(); objpay.SearchKey = Convert.ToString(SearchKey); List <string> MPN = new List <string>(); DataTable dt = new DataTable(); dt = objpay.SearchKeywordPayment(); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { MPN.Add(Server.HtmlDecode(dr["SearchKey"].ToString())); } } else { MPN.Add("No record found"); } return(MPN); }
public List <paymentManager> BindPaymentData(string id) { paymentManager objProduct = new paymentManager(); objProduct.paymentid = Convert.ToInt32(id); List <paymentManager> lmp = new List <paymentManager>(); DataTable dt = new DataTable(); dt = objProduct.GetSinglePaymentRecord(); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { paymentManager PMS = new paymentManager(); PMS.paymentid = Convert.ToInt32(dr["paymentid"].ToString()); PMS.orderid = Convert.ToInt32(dr["orderid"].ToString()); PMS.payammount = Convert.ToDecimal(dr["payammount"].ToString()); PMS.paynotes = dr["paynotes"].ToString(); PMS.contactName = dr["contactName"].ToString(); lmp.Add(PMS); } } return(lmp); }
//// get month //public void getMonth() //{ // var currentMonth = DateTime.Today.Month; // for (int i = 1; i <= 12; i++) // { // chkMonth.Items.Add(i.ToString()); // } //} //Bind order private void BindPayment(string search = "") { this.Form.DefaultButton = imgbtnSearch.UniqueID; paymentManager objPay = new paymentManager(); DataTable dtorder = new DataTable(); try { if (txtsearch.Text != "") { objPay.commonsearch = txtsearch.Text.Trim(); } //else if (Request.QueryString["orderid"] != null) //{ // objPay.commonsearch = Convert.ToInt32(Request.QueryString["orderid"]); //} else { objPay.commonsearch = ""; } //year filter if (chk2015.Checked == true && chk2016.Checked == true) { objPay.firstyear = Convert.ToInt32(PervYear.InnerText); objPay.lastyear = Convert.ToInt32(currYear.InnerText); } else if (chk2015.Checked == true) { objPay.firstyear = Convert.ToInt32(PervYear.InnerText); } else if (chk2016.Checked == true) { objPay.firstyear = Convert.ToInt32(currYear.InnerText); } else { objPay.firstyear = 0; objPay.lastyear = 0; } // month filter string strMonth = string.Empty; if (chk1.Checked == true) { strMonth += 1 + ","; } if (chk2.Checked == true) { strMonth += 2 + ","; } if (chk3.Checked == true) { strMonth += 3 + ","; } if (chk4.Checked == true) { strMonth += 4 + ","; } if (chk5.Checked == true) { strMonth += 5 + ","; } if (chk6.Checked == true) { strMonth += 6 + ","; } if (chk7.Checked == true) { strMonth += 7 + ","; } if (chk8.Checked == true) { strMonth += 8 + ","; } if (chk9.Checked == true) { strMonth += 9 + ","; } if (chk10.Checked == true) { strMonth += 10 + ","; } if (chk11.Checked == true) { strMonth += 11 + ","; } if (chk12.Checked == true) { strMonth += 12 + ","; } if (strMonth != "") { strMonth = strMonth.TrimEnd(','); var strTemp = strMonth.Split(','); for (int i = 0; i < strTemp.Count(); i++) { if (strTemp.Count() >= 2) { endmonth = Convert.ToInt32(strTemp[i]); } if (i == 0) { startmonth = Convert.ToInt32(strTemp[i]); } } } if (startmonth != 0) { objPay.startmonth = startmonth; } else { objPay.startmonth = startmonth; } if (endmonth != 0) { objPay.endmonth = endmonth; } else { objPay.endmonth = endmonth; } if (pageNo == 0) { pageNo = 1; } objPay.pageNo = pageNo; objPay.pageSize = pageSize; objPay.SortExpression = SortExpression; querystring = "&pageSize=" + ddlpageSize.SelectedValue + "&key=" + txtsearch.Text; dtorder = objPay.SearchItem(); totalrecs = objPay.TotalRecord; if (pageNo == 1) { objPay.pageNo = 1; pageNo = 1; } else if (pageNo == 0) { objPay.pageNo = 1; pageNo = 1; } else { objPay.pageNo = (pageNo - 1) * pageSize; } objPay.pageSize = pageSize; totalpages = totalrecs / pageSize; if ((totalrecs % pageSize) > 0 && (totalrecs > pageSize)) { totalpages += 1; } gvAdmin.DataSource = dtorder; gvAdmin.DataBind(); if (dtorder.Rows.Count > 0) { int startRowOnPage = (gvAdmin.PageIndex * gvAdmin.PageSize) + 1; int lastRowOnPage = startRowOnPage + gvAdmin.Rows.Count - 1; int totalRows = totalrecs; ltrcountrecord.Text = "<div class=\"countdiv\">Showing " + startRowOnPage.ToString() + " to " + lastRowOnPage + " of " + totalRows + " entries</div>"; } String strpaging = CommonFunctions.AdminPagingv2(totalpages, pageNo, querystring, "viewpayment.aspx"); ltrpaggingbottom.Text = strpaging; //Ltrup.Text = strpaging; //LoadDropDownList(); } catch (Exception ex) { throw ex; } finally { dtorder.Dispose(); objPay = null; } }