protected void GVAnnualReport_SelectedIndexChanged(object sender, EventArgs e) { try { clsAnnualrpt annual = new clsAnnualrpt(); objds = new DataSet(); annual.AnnualReportID = Convert.ToInt32(GVAnnualReport.SelectedDataKey.Value); annual.Action = "GetRpt"; objds = annual.insertAnnual(); if (objds.Tables.Count > 0) { objdt = objds.Tables[0]; pnl.Visible = true; RequiredFieldValidator2.Enabled = false; txtAnnualReportTitle.Text = objdt.Rows[0]["AnnualReportTitle"].ToString(); hpfile.Text = objdt.Rows[0]["AnnualReportFile"].ToString(); hpfile.NavigateUrl = "Upload/" + objdt.Rows[0]["AnnualReportFile"].ToString(); HFCommand.Value = "Update"; } } catch (Exception ex) { throw ex; } }
protected void btnSubmit_Click(object sender, ImageClickEventArgs e) { string sql; string AnnualReportID = ""; string sFileName = FUAnnualReportFile.FileName; if (HFCommand.Value == "AddNew") { annual = new clsAnnualrpt(); objds = new DataSet(); objdt = new DataTable(); DataTable objdt1 = new DataTable(); // AnnualReportID = Library.getSingleValue("select max(AnnualReportID)+1 from M_AnnualReport"); //sql = "Insert Into M_AnnualReport (AnnualReportTitle,AnnualReportFile)values ('" + txtAnnualReportTitle.Text.Trim().Replace("'", "''") + "','" + sFileName.Replace("'", "''") + "')"; annual.Action = "Insert"; if (sFileName != "") { sFileName = Uploader(sFileName, AnnualReportID); } annual.AnnualReportFile = sFileName; annual.AnnualReportTitle = txtAnnualReportTitle.Text; objds = annual.insertAnnual(); if (objds.Tables.Count > 0) { objdt = objds.Tables[0]; objdt1 = objds.Tables[1]; //if (objdt.Rows.Count > 0) //{ // AnnualReportID = objdt.Rows[0]["AnnualReportID"].ToString(); //} if (objdt1.Rows[0][0].ToString() == "1") { for (int i = 0; i < gvmemberEmail.Rows.Count; i++) { Label lblemail = (Label)gvmemberEmail.Rows[i].FindControl("lblemail"); string subject; string body; string to = lblemail.Text; string from = "*****@*****.**"; string ErrMsg; // int RegID = Convert.ToInt32(txtsrno.Text.Trim()); MailMessage email = new MailMessage(from, to); email.Subject = "New Annual Report- " + txtAnnualReportTitle.Text + ""; email.IsBodyHtml = true; email.Body = "<font size='2' face='Verdana, Arial, Helvetica, sans-serif'><b>Hello Customer,</b><br><br><br>This is to Inform That New Annual Report has been Added <BR> Please Refer Our Web-Site<BR><BR><br><b>From,<br>www.epilpa.org<BR>(Team)</b><br></font>"; string FileName = ""; SmtpClient mailclient = new SmtpClient(); System.Net.NetworkCredential basicAuthenticationInfo = new System.Net.NetworkCredential("*****@*****.**", "BYJ^$#@3"); mailclient.Host = "smtp.epilpa.org"; mailclient.Port = 25; mailclient.Timeout = 100000; mailclient.UseDefaultCredentials = false; mailclient.Credentials = basicAuthenticationInfo; ErrMsg = string.Empty; try { mailclient.Send(email); //return 1; } catch (Exception ex) { ErrMsg = ex.Message; //return 0; } } Label1.Visible = true; Label1.Text = "Insert Sucessfully..!!!!"; } } } else { // AnnualReportID = annual.AnnualReportID = Convert.ToInt32(GVAnnualReport.SelectedDataKey.Value.ToString()); if ((sFileName == "" || sFileName == null)) { sFileName = hpfile.Text; } else { sFileName = Uploader(sFileName, AnnualReportID); if (File.Exists(Server.MapPath("Upload/" + hpfile.Text))) { File.Delete(Server.MapPath("Upload/" + hpfile.Text)); } } annual.AnnualReportFile = sFileName; annual.AnnualReportTitle = txtAnnualReportTitle.Text; annual.Action = "Update"; objds = annual.insertAnnual(); } // Library.execNonQueryB(sql); FillGrid(); }