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