protected void Button1_Click(object sender, EventArgs e)
{
DataView dvieww;
string SMTP;
string BCC;
string EmailFrom;
string Password;
dvieww = (DataView)SqlDataSource8.Select(DataSourceSelectArguments.Empty);
SMTP = (string)dvieww.Table.Rows[0]["SMTP"];
BCC = (string)dvieww.Table.Rows[0]["BCC"];
EmailFrom = (string)dvieww.Table.Rows[0]["EmailFrom"];
Password = (string)dvieww.Table.Rows[0]["Password"];
MailMessage mail = new MailMessage();
SmtpClient SmtpServer = new SmtpClient(SMTP.ToString());
mail.From = new MailAddress(EmailFrom.ToString());
//Email acpe = new Email();
mail.To.Add(TextBox2.Text);
mail.Bcc.Add(BCC.ToString());
StreamReader reader = new StreamReader(Server.MapPath("~/email/Contact.html"));
string readFile = reader.ReadToEnd();
string myString = "";
myString = readFile;
//string name = HttpUtility.UrlEncode(Encrypt(Session["UserName"].ToString().Trim()));
//string technology = HttpUtility.UrlEncode(Encrypt(ddlTechnology.SelectedItem.Value));
myString = myString.Replace("{#Name}", TextBox1.Text);
myString = myString.Replace("{#Email}", TextBox2.Text);
myString = myString.Replace("{#Message}", TextBox3.Text);
//myString = myString.Replace("{#message}", TextBox4.Text);
mail.Subject = "New Contact on onlinehcs.com";
mail.IsBodyHtml = true;
mail.Body = myString.ToString();
SmtpServer.Port = 8889;
SmtpServer.Credentials = new System.Net.NetworkCredential(EmailFrom.ToString(), Password.ToString());
SmtpServer.EnableSsl = false;
object userState = mail;
SmtpServer.SendCompleted += new SendCompletedEventHandler(SMTPClientForAsy.SmtpClient_OnCompleted);
SmtpServer.SendAsync(mail, userState);
TextBox1.Text = string.Empty;
TextBox2.Text = string.Empty;
TextBox3.Text = string.Empty;
Label5.Text = "Submitted Successfully";
}
protected void Button3_Click(object sender, EventArgs e)
{
try
{
SqlDataSource8.SelectParameters["Codigo"].DefaultValue = TextBox6.Text;
SqlDataSource8.DataSourceMode = SqlDataSourceMode.DataReader;
SqlDataReader Producto;
Producto = (SqlDataReader)SqlDataSource8.Select(DataSourceSelectArguments.Empty);
if (Producto.Read())
{
TextBox7.Text = Producto["Descripcion"].ToString();
Label1.Text = Producto["ID_Producto"].ToString();
}
else
{
Response.Write("<script>alert('Este producto no existe')</script>");
}
}
catch
{
Response.Write("<script>alert('Ingrese un codigo!')</script>");
}
//DataTable TB = new DataTable();
//TB = datosProd.BuscarProducto2(TextBox6.Text);
//try
//{
// ViewState["Estado"] = TB;
// if (ViewState["Estado"] == null)
// {
// Response.Write("<script>alert('Este producto no existe')</script>");
// }
// else
// {
// TextBox7.Text = TB.Rows[0][1].ToString();
// }
//}
//catch
//{
// Response.Write("<script>alert('Este producto no existe')</script>");
//}
}
protected void Button3_Click(object sender, EventArgs e)
{
try
{
SqlDataSource8.SelectParameters["Codigo"].DefaultValue = TextBox6.Text;
SqlDataSource8.DataSourceMode = SqlDataSourceMode.DataReader;
SqlDataReader Producto;
Producto = (SqlDataReader)SqlDataSource8.Select(DataSourceSelectArguments.Empty);
if (Producto.Read())
{
TextBox7.Text = Producto["Descripcion"].ToString();
Label1.Text = Producto["ID_Producto"].ToString();
}
else
{
Response.Write("<script>alert('Este producto no existe')</script>");
}
}
catch
{
Response.Write("<script>alert('Ingrese un codigo!')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
DataView dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
DataRowView drv = dv[0];
Table1.Rows[1].Cells[0].Text = drv["BUGS"].ToString();
DataView dv1 = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
DataRowView drv1 = dv1[0];
Table1.Rows[1].Cells[1].Text = drv1["BUGS"].ToString();
DataView dv2 = (DataView)SqlDataSource3.Select(DataSourceSelectArguments.Empty);
DataRowView drv2 = dv2[0];
Table1.Rows[1].Cells[2].Text = drv2["BUGS"].ToString();
DataView dv3 = (DataView)SqlDataSource4.Select(DataSourceSelectArguments.Empty);
DataRowView drv3 = dv3[0];
Table1.Rows[1].Cells[3].Text = drv3["BUGS"].ToString();
DataView dv5 = (DataView)SqlDataSource5.Select(DataSourceSelectArguments.Empty);
DataRowView drv5 = dv5[0];
Table2.Rows[1].Cells[0].Text = drv5["BUGS"].ToString();
DataView dv6 = (DataView)SqlDataSource6.Select(DataSourceSelectArguments.Empty);
DataRowView drv6 = dv6[0];
Table2.Rows[1].Cells[1].Text = drv6["BUGS"].ToString();
DataView dv7 = (DataView)SqlDataSource7.Select(DataSourceSelectArguments.Empty);
DataRowView drv7 = dv7[0];
Table2.Rows[1].Cells[2].Text = drv7["BUGS"].ToString();
DataView dv8 = (DataView)SqlDataSource8.Select(DataSourceSelectArguments.Empty);
DataRowView drv8 = dv8[0];
Table2.Rows[1].Cells[3].Text = drv8["BUGS"].ToString();
DataView dv9 = (DataView)SqlDataSource9.Select(DataSourceSelectArguments.Empty);
DataRowView drv9 = dv9[0];
Table3.Rows[1].Cells[0].Text = drv9["BUGS"].ToString();
DataView dv10 = (DataView)SqlDataSource10.Select(DataSourceSelectArguments.Empty);
DataRowView drv10 = dv10[0];
Table3.Rows[1].Cells[1].Text = drv10["BUGS"].ToString();
DataView dv11 = (DataView)SqlDataSource11.Select(DataSourceSelectArguments.Empty);
DataRowView drv11 = dv11[0];
Table3.Rows[1].Cells[2].Text = drv11["BUGS"].ToString();
DataView dv12 = (DataView)SqlDataSource12.Select(DataSourceSelectArguments.Empty);
DataRowView drv12 = dv12[0];
Table3.Rows[1].Cells[3].Text = drv12["BUGS"].ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
Double oa = 0;
Double pb = 0;
DataView dv1 = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
Label1.Text = (string)dv1.Table.Rows[0][1];
Label2.Text = (string)dv1.Table.Rows[0][2];
DateTime rdate = (DateTime)dv1.Table.Rows[0][6];
Label3.Text = rdate.ToString("MM/dd/yyyy");
Double era = (Double)dv1.Table.Rows[0][4];
if (dv1.Table.Rows[0][5] is DBNull)
{
Label6.Text = ""; Label7.Text = "";
}
else
{
pb = (Double)dv1.Table.Rows[0][5];
Label6.Text = "Performance Bond";
Label7.Text = pb.ToString("n2");
}
if (dv1.Table.Rows[0][3] is DBNull)
{
}
else
{
oa = (Double)dv1.Table.Rows[0][3];
Label5.Text = oa.ToString("n2");
}
Label4.Text = era.ToString("n2");
era = oa + era + pb;
Label8.Text = era.ToString("n2");
if (dv1.Table.Rows[0][7] is DBNull)
{
Label9.Text = "No Reservation Fee.";
}
else
{
Double rf = (Double)dv1.Table.Rows[0][7];
Label9.Text = rf.ToString("n2");
}
int vid = (int)dv1.Table.Rows[0][8];
TextBox4.Text = vid.ToString();
TextBox8.Text = Request.QueryString["newId"];
DataView dvy = (DataView)SqlDataSource8.Select(DataSourceSelectArguments.Empty);
if ((int)dvy.Table.Rows[0][0] >= 1)
{
DataView dvx = (DataView)SqlDataSource6.Select(DataSourceSelectArguments.Empty);
Double tl = (Double)dvx.Table.Rows[0][0];
Label10.Text = tl.ToString("n2");
}
else
{
Label10.Text = "0";
}
DataView dva = (DataView)rsvamntyCount.Select(DataSourceSelectArguments.Empty);
if ((int)dva.Table.Rows[0][0] >= 1)
{
DataView dvb = (DataView)rsvamntySum.Select(DataSourceSelectArguments.Empty);
Double tl2 = (Double)dvb.Table.Rows[0][0];
Label12.Text = tl2.ToString("n2");
}
else
{
Label12.Text = "0";
}
DataView dvz = (DataView)rsvmiscCount.Select(DataSourceSelectArguments.Empty);
if ((int)dvz.Table.Rows[0][0] >= 1)
{
DataView dvw = (DataView)rsvmiscSum.Select(DataSourceSelectArguments.Empty);
Double tl3 = (Double)dvw.Table.Rows[0][0];
Label13.Text = tl3.ToString("n2");
}
else
{
Label13.Text = "0";
}
Label11.Text = "";
TextBox3.ReadOnly = true;
Double gtotal = Convert.ToDouble(Label8.Text) + Convert.ToDouble(Label10.Text) + Convert.ToDouble(Label12.Text) + Convert.ToDouble(Label13.Text);
Label14.Text = gtotal.ToString("n2");
rsvupdatetotal.Update();
}