void FillGridLMS_Payment() { if ((string)Session["AdminSessionID"] != null) { string xCode = Session["AdminSessionID"].ToString(); SqlDataAdapter GDA = new SqlDataAdapter(" " + " select Code, PDate=Convert(varchar(11),PaymentDate,113), ClientNAme=(Select Name from fp_Prospects " + " where Code=pd.clientcode), Amount,Instrument,Drawer,Drawee,Payer,Payee,PaymentMode, " + " PlannerName=(select PlannerName from fp_Planner where Code=pd.PlannerCode ), " + " EntryDate from fp_PaymentDetail pd where clientCode=" + ViewState["xClientCode"] + " " + " ", Con); DataSet GDS = new DataSet(); Con.Open(); GDA.Fill(GDS); Con.Close(); GridViewPayment.DataSource = GDS; GridViewPayment.DataBind(); } else { Response.Redirect("SessionExpired.aspx"); } }
protected void ShowData(string strFindPayment = "") { List <Payment> Payments = _db.Payments.Where(s => s.NameOfCourses.Contains(strFindPayment)).ToList(); GridViewPayment.DataSource = Payments; GridViewPayment.DataBind(); }
protected void btnSave_Click(object sender, EventArgs e) { SqlDataSourcePayment.InsertParameters["Acct_Id"].DefaultValue = Acct_Id.Text; SqlDataSourcePayment.InsertParameters["Status_Info"].DefaultValue = PaymentStatus.SelectedValue; SqlDataSourcePayment.InsertParameters["Payment_Date"].DefaultValue = txtPayment.Text.Trim(); SqlDataSourcePayment.InsertParameters["Quotation_Number"].DefaultValue = DropDownInvoice.SelectedValue; SqlDataSourcePayment.Insert(); GridViewPayment.DataBind(); panelAddPayment.Visible = false; panelSavePayment.Visible = true; Acct_Id.Text = string.Empty; PaymentStatus.SelectedIndex = -1; txtPayment.Text = string.Empty; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["user"] != null) { User us = (User)Session["user"]; if (us.RoleID == 1) { GridViewPayment.DataSource = ViewPaymentTypeController.getAllPaymentType(); GridViewPayment.DataBind(); } else { Response.Redirect("Home.aspx"); } } else { Response.Redirect("Home.aspx"); } } }