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");
}
}
}
