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();
}
