using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Data.SqlClient; public partial class UpdateDomain : System.Web.UI.Page { string stid; DateTime DRegDate; //SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["con"]); SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString); FillDD objFillDD = new FillDD(); DataSet ds = new DataSet(); protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["Id"] != null) { stid = Request.QueryString["Id"]; } if (!IsPostBack) { objFillDD.Get_DDList(ref DDDomainList, "Id", "DomainName", "tbl_DomainMaster", ref lblerr); objFillDD.Get_RecordsSelected(ref DDDomainList, stid, ref lblerr); fill_DDRegBy(); Get_DomainRecords(); fill_DgDetails(); } } void fill_DgDetails() { try { //string view = "Select Id,DomId,DomainName, convert(varchar(11),DRegDate,103)as DRegDate, convert(varchar(11),DExpDate,103)as DExpDate,convert(varchar(11),HRegDate,101)as HRegDate, convert(varchar(11),HExpDate,101)as HExpDate,HRegisterBy,HFtpUrl,HUid,HPass,HSpace,EntryBy,convert(varchar(10),EntryDate,103)as EntryDate,companyname from dbo.VW_DomainHosting Where DomId ='" + lblWhr1.Text + "' order by Id Desc"; SqlDataAdapter adp = new SqlDataAdapter("Select Id,DomainName, convert(varchar(11),DRegDate,101)as DRegDate, convert(varchar(11),DExpDate,101)as DExpDate,convert(varchar(11),HRegDate,101)as HRegDate, convert(varchar(11),HExpDate,101)as HExpDate,HRegisterBy,HFtpUrl,HUid,HPass,HSpace,EntryBy,convert(varchar(10),EntryDate,101)as EntryDate,companyname from dbo.VW_DomainHosting Where DomId='" + stid + "'", con); adp.Fill(ds, "DH1"); DGDetails.DataSource = ds.Tables["DH1"]; DGDetails.DataBind(); } catch (Exception exp) { lblDgerr.Text = ("DG Alert! : " + exp.Message); } } void Get_DomainRecords() { try { if ((con.State == ConnectionState.Open)) { con.Close(); } SqlCommand cmd = new SqlCommand("Select convert(varchar(11),DRegDate,101)as DRegDate,DPeriod,DRegisterBy,DReNew from tbl_DomainHosting Where DomainName=" + stid + "", con); SqlDataReader dr; con.Open(); dr = cmd.ExecuteReader(); if (dr.Read()) { string StrDRegDt, StrDExp, StrDRegby; StrDRegDt = dr["DRegDate"].ToString().Trim(); StrDExp = dr["DPeriod"].ToString().Trim(); lblDRenew.Text = dr["DReNew"].ToString().Trim(); StrDRegby = dr["DRegisterBy"].ToString().Trim(); if (StrDRegDt != "" && StrDExp != "") { txtDRegDt.Text = StrDRegDt; lblDchk.Text = "Yes"; } else { lblDchk.Text = "No"; } objFillDD.Get_RecordsSelected(ref DDDExpdt, StrDExp, ref lblerr); objFillDD.Get_RecordsSelected(ref DDDRegby, StrDRegby, ref lblerr); } else { lblDchk.Text = "No"; } } catch (Exception ex) { lblerr.Text = "Error :" + ex.Message; } finally { con.Close(); } } protected void btnUpdate_Click(object sender, ImageClickEventArgs e) { try { if (DDDomainList.SelectedItem.Value == "0") { lblerr.Text = "Alert! : Select Domain Name"; } else if (tbl_DomD.Visible == true && txtDRegDt.Text == "") { lblerr.Text = "Alert! : Please Select Domain Registration Date"; } else if (tbl_DomD.Visible == true && DDDExpdt.SelectedItem.Value == "0") { lblerr.Text = "Alert! : Please Select Domain Expiry on"; } else if (tbl_DomD.Visible == true && DDDRegby.SelectedItem.Value == "0") { lblerr.Text = "Alert! : Please Select Domain Registred by Company"; } else { if (txtDRegDt.Text != "") { DRegDate = Convert.ToDateTime(txtDRegDt.Text); DRegDate = DRegDate.AddYears(Convert.ToInt32(DDDExpdt.SelectedItem.Value)); DRegDate = DRegDate.AddDays(-1); lblDexp.Text = Convert.ToString(DRegDate); } if (con.State == ConnectionState.Closed) { con.Open(); } string update = "update tbl_DomainHosting set DRegDate='" + txtDRegDt.Text + "', DPeriod='" + Convert.ToInt32(DDDExpdt.SelectedItem.Value) + "', DExpDate='" + lblDexp.Text + "', DRegisterBy='" + DDDRegby.SelectedItem.Value + "', EntryBy='" + Session["AdminAuth"] + "', EntryDate='" + DateTime.Today + "' where DomainName='" + DDDomainList.SelectedItem.Value + "'"; SqlCommand cm3 = new SqlCommand(update, con); cm3.ExecuteNonQuery(); con.Close(); fill_DgDetails(); lblerr.Text = "Domain details Updated Successfully"; } } catch (Exception ex) { lblerr.Text = "Update Alert! : " + ex.Message; } } void fill_DDRegBy() { objFillDD.Get_DDList(ref DDDRegby, "Id", "CompanyName", "tbl_RegisteredBy", ref lblerr); } protected void OnPageChange(object source, DataGridPageChangedEventArgs e) { try { lblDgerr.Text = ""; DGDetails.CurrentPageIndex = e.NewPageIndex; fill_DgDetails(); } catch (Exception exp) { lblDgerr.Text = ("DG Alert! : " + exp.Message); } } }