public void BindDDL() { DataTable dtAdvertiser = AdvertiserClass.GetAllAdvertiser(); if (dtAdvertiser.Rows.Count > 0) { ddlAdvertise.DataTextField = "AdvertiserName"; ddlAdvertise.DataValueField = "AdvertiserIDP"; ddlAdvertise.DataSource = dtAdvertiser; ddlAdvertise.DataBind(); ddlAdvertise.Items.Insert(0, new ListItem("--Select State--", "-1")); ddlAdvertise.SelectedIndex = 0; } DataTable dtPlan = PlanClass.GetAllPlan(); if (dtPlan.Rows.Count > 0) { ddlAdvertisePlan.DataTextField = "PlanTitle"; ddlAdvertisePlan.DataValueField = "PlanIDP"; ddlAdvertisePlan.DataSource = dtPlan; ddlAdvertisePlan.DataBind(); ddlAdvertisePlan.Items.Insert(0, new ListItem("--Select State--", "-1")); ddlAdvertisePlan.SelectedIndex = 0; } }
protected void rptData_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandArgument != null) { Int64 AdvertiserIDP = Int64.Parse(e.CommandArgument.ToString()); switch (e.CommandName) { case "cEdit": hfID.Value = AdvertiserIDP.ToString(); DataTable dtGetAdvertiser = AdvertiserClass.GetAdvertiser_ByID(AdvertiserIDP); if (dtGetAdvertiser.Rows.Count > 0) { DataRow dr = dtGetAdvertiser.Rows[0]; tbAdvertiserName.Text = dr["AdvertiserName"].ToString(); tbEmailID.Text = dr["EmailID"].ToString(); ddlState.SelectedValue = (dr["StateIDF"].ToString() == "0" ? "-1" : dr["StateIDF"].ToString()); Int64 mStateIDF = 0; Int64.TryParse(dr["StateIDF"].ToString(), out mStateIDF); if (mStateIDF > 0) { BindCity(mStateIDF); } ddlCity.SelectedValue = (dr["CityIDF"].ToString() == "0" ? "-1" : dr["CityIDF"].ToString()); tbDOB.Text = (!string.IsNullOrEmpty(dr["DOB"].ToString()) ? Convert.ToDateTime(dr["DOB"].ToString()).ToString(MyLogic.DateFormat) : ""); tbAddress.Text = dr["Address"].ToString(); tbMobileNo.Text = dr["MobileNo"].ToString(); tbUserName.Text = dr["UserName"].ToString(); tbPassword.Text = dr["Password"].ToString(); cbIsActive.Checked = bool.Parse(dr["IsActive"].ToString()); pnC.Visible = true; pnG.Visible = false; btAddNew.Visible = false; } break; case "cDelete": MEMBERS.SQLReturnValue mRes = AdvertiserClass.DeleteAdvertiser_ByID(AdvertiserIDP); ScriptManager.RegisterStartupScript(this, this.GetType(), "noti", "setMessage('<b>" + mRes.MessageFromSQL + "</b>',1);", true); ClearControls(); BindData(); break; } } }
protected void btSave_Click(object sender, EventArgs e) { AdvertiserClass obj = new AdvertiserClass(); obj.AdvertiserName = tbAdvertiserName.Text; obj.EmailID = tbEmailID.Text; Int64 mStateIDF = 0, mCityIDF = 0; Int64.TryParse(ddlState.SelectedValue, out mStateIDF); Int64.TryParse(ddlCity.SelectedValue, out mCityIDF); obj.StateIDF = mStateIDF; obj.CityIDF = mCityIDF; obj.Address = tbAddress.Text; obj.MobileNo = tbMobileNo.Text; obj.IsActive = cbIsActive.Checked; obj.UserName = tbUserName.Text; obj.Password = tbPassword.Text; obj.UserID = 0; if (!string.IsNullOrEmpty(tbDOB.Text)) { obj.DOB = MyLogic.GetDateFormatProper(tbDOB.Text); } MEMBERS.SQLReturnValue mRes; if (hfID.Value == string.Empty) { obj.Flag = "ADD"; mRes = AdvertiserClass.Insert_Update_Advertiser(obj); } else { obj.Flag = "EDIT"; obj.AdvertiserIDP = Int64.Parse(hfID.Value); mRes = AdvertiserClass.Insert_Update_Advertiser(obj); } ScriptManager.RegisterStartupScript(this, this.GetType(), "noti", "setMessage('<b>" + mRes.MessageFromSQL + "</b>',1);", true); ClearControls(); BindData(); pnC.Visible = false; pnG.Visible = true; btAddNew.Visible = true; }
public void BindData() { Int64 AdvertiserIDP = 0; Int64.TryParse(MyLogic.GetUserID, out AdvertiserIDP); hfID.Value = AdvertiserIDP.ToString(); DataTable dtGetAdvertiser = AdvertiserClass.GetAdvertiser_ByID(AdvertiserIDP); if (dtGetAdvertiser.Rows.Count > 0) { DataRow dr = dtGetAdvertiser.Rows[0]; tbAdvertiserName.Text = dr["AdvertiserName"].ToString(); tbEmailID.Text = dr["EmailID"].ToString(); ddlState.SelectedValue = (dr["StateIDF"].ToString() == "0" ? "-1" : dr["StateIDF"].ToString()); Int64 mStateIDF = 0; Int64.TryParse(dr["StateIDF"].ToString(), out mStateIDF); if (mStateIDF > 0) { BindCity(mStateIDF); } ddlCity.SelectedValue = (dr["CityIDF"].ToString() == "0" ? "-1" : dr["CityIDF"].ToString()); tbDOB.Text = (!string.IsNullOrEmpty(dr["DOB"].ToString()) ? Convert.ToDateTime(dr["DOB"].ToString()).ToString(MyLogic.DateFormat) : ""); tbAddress.Text = dr["Address"].ToString(); tbMobileNo.Text = dr["MobileNo"].ToString(); tbUserName.Text = dr["UserName"].ToString(); tbPassword.Text = dr["Password"].ToString(); } }
public void BindData() { rptData.DataSource = AdvertiserClass.GetAllAdvertiser(); rptData.DataBind(); }