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