protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { //GridPosed.DataSource = GetPPR(); //GridPosed.DataBind(); btnSubmit.Visible = false; DataTable dtt = new DataTable(); dtt = GetPPR(); if (dtt.Rows.Count > 0) { for (int i = 0; i < dtt.Rows.Count; i++) { dtt.Rows[i]["PPR"] = HttpUtility.HtmlDecode(dtt.Rows[i]["PPR"].ToString()); } } ddlPPRID.DataSource = dtt; ddlPPRID.DataTextField = "PPR"; ddlPPRID.DataValueField = "PPRId"; ddlPPRID.DataBind(); ddlPPRID.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---Select ---", "")); GridPosedDetails.DataSource = GetPPRDetails(); GridPosedDetails.DataBind(); if (Request.QueryString["pPoseID"] != null && dtt.Rows.Count > 0) { ddlPPRID.SelectedValue = Request.QueryString["pPoseID"].ToString(); ddlPPRID_SelectedIndexChanged(this, e); } } catch (Exception ex) { LogError(ex); } } }
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); } }