using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class RenewDatabase : System.Web.UI.Page { SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString); //SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["con"]); DateTime DExpDate; protected void Page_Load(object sender, EventArgs e) { lblId.Text = Request.QueryString["Id"]; Get_DomainRecords(); } void Get_DomainRecords() { try { if ((con.State == ConnectionState.Open)) { con.Close(); } SqlCommand cmd = new SqlCommand("Select ClientName, DomainId,DomainName,CompNameDb,convert(varchar(11),DbRegDate,101)as DbRegDate,DbPeriod,CompanyName, convert(varchar(11),DbExpDate,101)as DbExpDate,DbUrl,DbName,DbUid,DbPass,DbSpace from VW_DBaseEmail Where Id=" + lblId.Text + "", con); SqlDataReader dr; con.Open(); dr = cmd.ExecuteReader(); if (dr.Read()) { lblDbId.Text = dr["DomainId"].ToString().Trim(); lblDomainName.Text = dr["DomainName"].ToString().Trim(); lblClientName.Text = dr["ClientName"].ToString().Trim(); lblDbRegDt.Text = dr["DbRegDate"].ToString().Trim(); lblDbRegFor.Text = dr["DbPeriod"].ToString().Trim() + " Year"; lblDbRegby.Text = dr["CompanyName"].ToString().Trim(); lblDbExpdt.Text = dr["DbExpDate"].ToString().Trim(); lblDbUrl.Text = dr["DbUrl"].ToString().Trim(); lblDbName.Text = dr["DbName"].ToString().Trim(); lblDbUid.Text = dr["DbUid"].ToString().Trim(); lblDbPass.Text = dr["DbPass"].ToString().Trim(); lblDbSpace.Text = dr["DbSpace"].ToString().Trim(); if (lblDbRegDt.Text == "" && lblDbExpdt.Text == "") { lblDbRegDt.Text = ""; lblDbExpdt.Text = ""; } } } catch (Exception ex) { lblerr.Text = "Error :" + ex.Message; } finally { con.Close(); } } protected void btnSubmit_Click(object sender, ImageClickEventArgs e) { if (DDDExpdt.SelectedItem.Value == "0") { lblerr.Text = "Alert : Please select Renew by no of years"; } else { Renew(); } } void Renew() { try { SqlCommand cmd = new SqlCommand("SpRenewDatabase", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Id", lblId.Text)); cmd.Parameters.Add(new SqlParameter("@DomainId", lblDbId.Text)); //cmd.Parameters.Add(new SqlParameter("@ReNewItem", "Database")); cmd.Parameters.Add(new SqlParameter("@ReNewFor", DDDExpdt.SelectedItem.Value)); cmd.Parameters.Add(new SqlParameter("@DbExpDt", Convert.ToDateTime(lblExpon.Text))); cmd.Parameters.Add(new SqlParameter("@EntryBy", Session["AdminAuth"])); cmd.Parameters.Add(new SqlParameter("@EntryDate", DateTime.Today)); con.Open(); cmd.ExecuteNonQuery(); lblerr.Text = "Database Renew successfull"; } catch (Exception exp) { lblerr.Text = ("Renew Alert! : " + exp.Message); } finally { con.Close(); } } protected void DDDExpdt_SelectedIndexChanged(object sender, EventArgs e) { DateTime DExpDate; if (DDDExpdt.SelectedItem.Value != "0") { DExpDate = Convert.ToDateTime(lblDbExpdt.Text); DExpDate = DExpDate.AddYears(Convert.ToInt32(DDDExpdt.SelectedItem.Value)); lblExpon.Text = Convert.ToString(DExpDate.Month + "/" + DExpDate.Day + "/" + DExpDate.Year); } else if (DDDExpdt.SelectedItem.Value == "0") { lblExpon.Text = ""; } } }