protected void rptData_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        if (e.CommandArgument != null)
        {
            Int64 AdvertiserPlanIDP = Int64.Parse(e.CommandArgument.ToString());
            switch (e.CommandName)
            {
            case "cEdit":
                hfID.Value = AdvertiserPlanIDP.ToString();
                DataTable dtAdvertiserPlan = SetPlanInAdvertiserClass.GetAdvertiserPlan_ByID(AdvertiserPlanIDP);
                if (dtAdvertiserPlan.Rows.Count > 0)
                {
                    DataRow dr = dtAdvertiserPlan.Rows[0];

                    ddlAdvertise.SelectedValue     = (dr["AdvertiserIDF"].ToString() == "0" ? "-1" : dr["AdvertiserIDF"].ToString());
                    ddlAdvertisePlan.SelectedValue = (dr["PlanIDF"].ToString() == "0" ? "-1" : dr["PlanIDF"].ToString());

                    tbPlanStartDate.Text = (!string.IsNullOrEmpty(dr["PlanStartDate"].ToString()) ? Convert.ToDateTime(dr["PlanStartDate"].ToString()).ToString(MyLogic.DateFormat) : "");
                    tbPlanEndDate.Text   = (!string.IsNullOrEmpty(dr["PlanEndDate"].ToString()) ? Convert.ToDateTime(dr["PlanEndDate"].ToString()).ToString(MyLogic.DateFormat) : "");

                    pnC.Visible      = true;
                    pnG.Visible      = false;
                    btAddNew.Visible = false;
                }
                break;

            case "cDelete":
                MEMBERS.SQLReturnValue mRes = SetPlanInAdvertiserClass.DeleteAdvertiserPlan_ByID(AdvertiserPlanIDP);
                ScriptManager.RegisterStartupScript(this, this.GetType(), "noti", "setMessage('<b>" + mRes.MessageFromSQL + "</b>',1);", true);
                ClearControls();
                BindData();
                break;
            }
        }
    }
    protected void btSave_Click(object sender, EventArgs e)
    {
        SetPlanInAdvertiserClass obj = new SetPlanInAdvertiserClass();

        Int64 mAdvertiserIDF = 0, mPlanIDF = 0;

        Int64.TryParse(ddlAdvertise.SelectedValue, out mAdvertiserIDF);
        Int64.TryParse(ddlAdvertisePlan.SelectedValue, out mPlanIDF);

        obj.AdvertiserIDF = mAdvertiserIDF;
        obj.PlanIDF       = mPlanIDF;

        if (!string.IsNullOrEmpty(tbPlanStartDate.Text))
        {
            obj.PlanStartDate = MyLogic.GetDateFormatProper(tbPlanStartDate.Text);
        }

        if (!string.IsNullOrEmpty(tbPlanEndDate.Text))
        {
            obj.PlanEndDate = MyLogic.GetDateFormatProper(tbPlanEndDate.Text);
        }
        MEMBERS.SQLReturnValue mRes;
        if (hfID.Value == string.Empty)
        {
            obj.Flag = "ADD";
            mRes     = SetPlanInAdvertiserClass.Insert_Update_Advertiser_Plan(obj);
        }
        else
        {
            obj.Flag = "EDIT";
            obj.AdvertiserPlanIDP = Int64.Parse(hfID.Value);
            mRes = SetPlanInAdvertiserClass.Insert_Update_Advertiser_Plan(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()
 {
     rptData.DataSource = SetPlanInAdvertiserClass.GetAllAdvertiserPlan();
     rptData.DataBind();
 }