protected void ddlPPRID_SelectedIndexChanged(object sender, EventArgs e) { if (ddlPPRID.SelectedValue != "") { string PPRID = ddlPPRID.SelectedValue; DataTable dt = this.GetPPR(); DataView dataView = dt.DefaultView; if (!string.IsNullOrEmpty(PPRID)) { dataView.RowFilter = "PPRId = '" + PPRID + "'"; } GridPosed.DataSource = dataView; GridPosed.DataBind(); if (GridPosed.Rows.Count > 0) { btnSubmit.Visible = true; } else { btnSubmit.Visible = false; } } else { GridPosed.DataSource = null; GridPosed.DataBind(); btnSubmit.Visible = false; } }
protected void GridPosed_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridPosed.PageIndex = e.NewPageIndex; GridPosed.DataSource = GetPPR(); GridPosed.DataBind(); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { DataTable dt = new DataTable(); MailUtility objm = new MailUtility(); string Errmessage = string.Empty; string Succmessage = string.Empty; int countercheck = 0; for (int i = 0; i < GridPosed.Rows.Count; i++) { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = ConfigurationManager.ConnectionStrings["PPRSqlConnection"].ConnectionString; using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = "USP_UpdatePPRforPosing"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PPRId", (GridPosed.Rows[i].FindControl("hdnPPRId") as HiddenField).Value); cmd.Parameters.AddWithValue("@Date", CommonUtility.getmmddyyyy((GridPosed.Rows[i].FindControl("txtMeetingDate") as TextBox).Text)); cmd.Parameters.AddWithValue("@PosedMDBID", (GridPosed.Rows[i].FindControl("ddlMDB") as DropDownList).SelectedValue); cmd.Parameters.AddWithValue("@LoanPosedID", (GridPosed.Rows[i].FindControl("ddlLoanPosed") as DropDownList).SelectedValue); cmd.Parameters.AddWithValue("@PosedBy", Session["UserId"] != null ? Session["UserId"].ToString():"0"); string folderPath = Server.MapPath("~/writedata/PosedDocument/"); string filename = Session["UserId"] != null ? Session["UserId"].ToString() : ""; string ToMailId = string.Empty; filename = "PosedDoc_" + filename + HttpUtility.HtmlEncode((GridPosed.Rows[i].FindControl("ddlMDB") as DropDownList).SelectedValue + ((GridPosed.Rows[i].FindControl("hdnPPRId") as HiddenField).Value) + CommonUtility.GetDate(DateTime.Now)); cmd.Parameters.AddWithValue("@PosedDocName", filename); FileUpload fileu = (GridPosed.Rows[i].FindControl("fluPosedDoc") as FileUpload); cmd.Connection = conn; conn.Open(); if (ValidatePDF(fileu)) { if (fileu.HasFile == true) { fileu.PostedFile.SaveAs(folderPath + "\\" + filename + ".pdf"); } cmd.ExecuteNonQuery(); conn.Close(); Succmessage = Succmessage != "" ? Succmessage + ", " + (GridPosed.Rows[i].FindControl("hdnPPRId") as HiddenField).Value : (GridPosed.Rows[i].FindControl("hdnPPRId") as HiddenField).Value; DataSet ds = new DataSet(); ds = getMailDetails((GridPosed.Rows[i].FindControl("hdnPPRId") as HiddenField).Value, (GridPosed.Rows[i].FindControl("ddlMDB") as DropDownList).SelectedValue); for (int j = 0; j < ds.Tables[0].Rows.Count; j++) { ToMailId = ToMailId + ds.Tables[0].Rows[j]["N_Email"].ToString() + ","; } //SaveNotification(Session["LoginId"] != null ? Session["LoginId"].ToString() : "0", "message", dte.Rows[i]["UserId"].ToString(), (GridPosed.Rows[i].FindControl("hdnPPRId") as HiddenField).Value), "4", "~/Authenticate/posing/acknowledgement.aspx", "~/Authenticate/LinMin/MeetingNotice.aspx", "0"); objm.SendPosedPPRmail(ToMailId, HttpUtility.HtmlDecode((GridPosed.Rows[i].FindControl("lblPPRID") as Label).Text), folderPath + filename + ".pdf", (GridPosed.Rows[i].FindControl("txtMeetingDate") as TextBox).Text, (GridPosed.Rows[i].FindControl("ddlMDB") as DropDownList).SelectedItem.ToString()); } else { Alert.show(lblMessage.Text); return; } } } } Alert.show("PPR ID" + Succmessage + " is posed successfully"); lblMessage.Text = "PPR ID" + Succmessage + " is posed successfully"; GridPosedDetails.DataSource = GetPPRDetails(); GridPosedDetails.DataBind(); ddlPPRID.DataSource = GetPPR(); ddlPPRID.DataTextField = "PPR"; ddlPPRID.DataValueField = "PPRId"; ddlPPRID.DataBind(); ddlPPRID.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---Select ---", "")); GridPosed.DataSource = null; GridPosed.DataBind(); btnSubmit.Visible = false; } catch (Exception ex) { LogError(ex); } }