private void Bind()
{
clsTbSub_Vendor_Team SVT = new clsTbSub_Vendor_Team();
//SVT.iSub_Vendor_ID = Convert.ToInt32(ddlCompanyName.SelectedValue.ToString());
DataTable dt = SVT.SelectAll();
gvClientsList.DataSource = dt;
gvClientsList.DataBind();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (ddlCompanyName.Text == "Select" || txtName.Text == "")
{
lblerr.Text = "* Marked fields are Compulsory";
}
else
{
clsTbSub_Vendor_Team SVT = new clsTbSub_Vendor_Team();
SVT.sName = txtName.Text.Trim();
SVT.iSub_Vendor_ID = Convert.ToInt32(ddlCompanyName.SelectedValue.ToString());
SVT.sStatus = ddlStatus.SelectedValue.ToString();
SVT.sType = ddlType.SelectedValue.ToString();
SVT.sEmail = txtEmail.Text.Trim();
SVT.sPrimary_Phone = txtPrimaryPhone.Text.Trim();
SVT.sSecondary_Phone = txtSecondaryPhone.Text.Trim();
SVT.sLocation = txtLocation.Text.Trim();
SVT.sAddress_Line1 = txtAddress_Line1.Text.Trim();
SVT.sAddress_Line2 = txtAddress_Line2.Text.Trim();
SVT.sCity = txtCity.Text.Trim();
SVT.sState = txtState.Text.Trim();
SVT.sZip = txtZIP.Text.Trim();
SVT.sCountry = txtCountry.Text.Trim();
if (string.IsNullOrEmpty(Request.QueryString["ID"]))
{
SVT.daCDate = Convert.ToDateTime(DateTime.Now);
SVT.sCPerson = Session["UserName"].ToString();
SVT.Insert();
lblerr.Text = "Successfully Registered";
Bind();
}
else
{
int i = Convert.ToInt32(Request.QueryString["id"].ToString());
SVT.iID = i;
SVT.Update();
lblerr.Text = "Updated Successfully";
Bind();
}
txtName.Text = "";
txtEmail.Text = "";
txtPrimaryPhone.Text = "";
txtSecondaryPhone.Text = "";
txtLocation.Text = "";
txtAddress_Line1.Text = "";
txtAddress_Line2.Text = "";
txtCity.Text = "";
txtState.Text = "";
txtZIP.Text = "";
txtCountry.Text = "";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
HtmlGenericControl li = (HtmlGenericControl)(Page.Master.FindControl("SubVendorTeam"));
li.Attributes["Class"] = "active";
clsTbSub_Vendor SV = new clsTbSub_Vendor();
DataTable dt = SV.SelectAll();
ddlCompanyName.DataSource = dt;
ddlCompanyName.DataTextField = "Company_Name";
ddlCompanyName.DataValueField = "ID";
ddlCompanyName.DataBind();
ddlCompanyName.Items.Insert(0, "Select");
Bind();
if (string.IsNullOrEmpty(Request.QueryString["ID"]))
{
// Response.Redirect("~/Admin/CreateClient.aspx");
}
else
{
int i = Convert.ToInt32(Request.QueryString["id"].ToString());
clsTbSub_Vendor_Team SVT = new clsTbSub_Vendor_Team();
SVT.iID = i;
DataTable dt1 = SVT.SelectOneWIDLogic();
if (dt1.Rows.Count > 0)
{
ddlCompanyName.SelectedValue = dt1.Rows[0]["Sub_Vendor_ID"].ToString();
txtName.Text = dt1.Rows[0]["Name"].ToString();
ddlStatus.SelectedValue = dt1.Rows[0]["Status"].ToString();
ddlType.SelectedValue = dt1.Rows[0]["Type"].ToString();
txtEmail.Text = dt1.Rows[0]["Email"].ToString();
txtPrimaryPhone.Text = dt1.Rows[0]["Primary_Phone"].ToString();
txtSecondaryPhone.Text = dt1.Rows[0]["Secondary_Phone"].ToString();
txtLocation.Text = dt1.Rows[0]["Location"].ToString();
txtAddress_Line1.Text = dt1.Rows[0]["Address_Line1"].ToString();
txtAddress_Line2.Text = dt1.Rows[0]["Address_Line2"].ToString();
txtCity.Text = dt1.Rows[0]["City"].ToString();
txtState.Text = dt1.Rows[0]["State"].ToString();
txtZIP.Text = dt1.Rows[0]["Zip"].ToString();
txtCountry.Text = dt1.Rows[0]["Country"].ToString();
}
}
}
}
