protected void BindMenuCategory() { DataSet ds = new DataSet(); ds = cls.ReturnDataSet("Select_CategoryForMenu"); rptMenuCategory.DataSource = ds; rptMenuCategory.DataBind(); }
public void bindCategory() { DataSet ds = new DataSet(); ds = cls.ReturnDataSet("Select_FAQCatName"); rptrFAQCategories.DataSource = ds; rptrFAQCategories.DataBind(); }
private void BindUnit() { DataSet ds = new DataSet(); ds = cls.ReturnDataSet("sp_RetriveData", new SqlParameter("@TblNm", "Unit"), new SqlParameter("@strWhereClause", "where IsActive = 1 Order By Id asc")); rptr.DataSource = ds; rptr.DataBind(); }
void BindPincodeChecker() { DataSet ds = new DataSet(); ds = cls.ReturnDataSet("sp_RetriveData", new SqlParameter("@TblNm", "PincodeChecker"), new SqlParameter("@strWhereClause", "Order By Id asc")); rptr.DataSource = ds; rptr.DataBind(); }
void BindManageUser() { DataSet ds = new DataSet(); ds = cls.ReturnDataSet("sp_RetriveData", new SqlParameter("@TblNm", "Members"), new SqlParameter("@strWhereClause", "where IsActive = 1 Order By MemberId asc")); rptr.DataSource = ds; rptr.DataBind(); }
private void BindAdvertisement() { DataSet ds = new DataSet(); ds = cls.ReturnDataSet("sp_RetriveData", new SqlParameter("@TblNm", "HomeAdd"), new SqlParameter("@strWhereClause", "where IsActive=1 order by Id Asc")); rptr.DataSource = ds; rptr.DataBind(); }
protected void BindContactUs() { DataSet ds = new DataSet(); ds = cls.ReturnDataSet("RetriveData_Alias", new SqlParameter("@Field", "*"), new SqlParameter("@TblNm", "ContactUs"), new SqlParameter("@WhereClause", "where ContactUs.IsActive = 1")); rptr.DataSource = ds; rptr.DataBind(); }
public void bindDisclaimer() { DataSet ds = new DataSet(); ds = cls.ReturnDataSet("sp_RetriveData", new SqlParameter("@TblNm", "Disclaimer"), new SqlParameter("@strWhereClause", "where Id=1")); if (ds.Tables[0].Rows.Count > 0) { ltrDisclaimer.Text = ds.Tables[0].Rows[0].ItemArray[1].ToString(); } }
private void BindProductSubCategory() { DataSet ds = new DataSet(); ds = cls.ReturnDataSet("RetriveData_Alias", new SqlParameter("@Field", "*"), new SqlParameter("@TblNm", "ProductSubCategory inner join ProductCategory on ProductSubCategory.ProductCategoryId=ProductCategory.Id"), new SqlParameter("@WhereClause", "where ProductSubCategory.IsActive = 1 Order By CategoryName asc")); rptr.DataSource = ds; rptr.DataBind(); }
public void bindTremsNCondition() { DataSet ds = new DataSet(); ds = cls.ReturnDataSet("sp_RetriveData", new SqlParameter("@TblNm", "TermsNConditions"), new SqlParameter("@strWhereClause", "where Id=1")); if (ds.Tables[0].Rows.Count > 0) { ltrtremscondition.Text = ds.Tables[0].Rows[0].ItemArray[1].ToString(); } }
protected void BindDescription() { DataSet ds = new DataSet(); ds = cls.ReturnDataSet("RetriveData_Alias", new SqlParameter("@Field", "*"), new SqlParameter("@TblNm", "Disclaimer"), new SqlParameter("@WhereClause", "where Disclaimer.IsActive = 1")); rptr.DataSource = ds; rptr.DataBind(); }
protected void rptr_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "Edit") { lblMsg.Text = ""; DataSet dset = new DataSet(); dset = clscon.ReturnDataSet("RetriveData", new SqlParameter("TblNm", "CourierMaster"), new SqlParameter("strwhereclause", "where ID = " + e.CommandArgument + " ")); if (dset.Tables[0].Rows.Count > 0) { DataRow dRow = null; foreach (DataRow dRow_loopVariable in dset.Tables[0].Rows) { dRow = dRow_loopVariable; txtCourierName.Text = dRow["CourierName"].ToString(); txtUrl.Text = dRow["Url"].ToString(); lblId.Text = e.CommandArgument.ToString(); } } } else if (e.CommandName == "Delete") { clscon.ExecuteDA("Delete_CourierMaster", new SqlParameter("@ID", e.CommandArgument.ToString())); BindData(); lblMsg.Text = "Record deleted successfully."; } }
protected void rptr_OnItemCommand(object sender, RepeaterCommandEventArgs e) { if (e.CommandName == "Edit") { lblMsg.Text = ""; DataSet dset = new DataSet(); dset = cls.ReturnDataSet("sp_RetriveData", new SqlParameter("TblNm", "CurrentOpenings"), new SqlParameter("strwhereclause", "where CurrentOpeningID = " + e.CommandArgument + " ")); if (dset.Tables[0].Rows.Count > 0) { DataRow dRow = null; foreach (DataRow dRow_loopVariable in dset.Tables[0].Rows) { dRow = dRow_loopVariable; txtDesignation.Text = dRow["Designation"].ToString(); txtPosition.Text = dRow["Position"].ToString(); txtNoOfPosition.Text = dRow["NoOfPosition"].ToString(); txtLocation.Text = dRow["Location"].ToString(); // txtDatePosted.Text = dRow["DatePosted"].ToString(); txtRequirements.Text = dRow["Requirements"].ToString(); txtResponsiblities.Text = dRow["Responsibilities"].ToString(); lblId.Text = e.CommandArgument.ToString(); } } } else if (e.CommandName == "Delete") { cls.ExecuteDA("Delete_CurrentOpenings", new SqlParameter("@CurrentOpeningID", e.CommandArgument.ToString())); BindCurrentOpenings(); lblMsg.Text = "Record deleted successfully."; } }
protected void BindAdd() { DataSet ds = new DataSet(); ds = cls.ReturnDataSet("Select_Add"); rptrAdd.DataSource = ds; rptrAdd.DataBind(); }
public void bindCarrer() { DataSet ds = new DataSet(); ds = cls.ReturnDataSet("sp_RetriveData", new SqlParameter("@TblNm", "CurrentOpenings"), new SqlParameter("@strWhereClause", "where IsActive=1")); rptrCarrer.DataSource = ds; rptrCarrer.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { DataSet ds = new DataSet(); ds = cls.ReturnDataSet("sp_RetriveData", new SqlParameter("@TblNm", "Brand"), new SqlParameter("@strWhereClause", "where IsActive=1 order by Id Asc")); rptr.DataSource = ds; rptr.DataBind(); }
protected void rptr_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "EditGroup") { DataSet ds = new DataSet(); ds = cls.ReturnDataSet("sp_RetriveDataWithField", new SqlParameter("@Fields", "*"), new SqlParameter("@TblNm", "Newsletter"), new SqlParameter("@WhereClause", "FAQ where NewsletterID ='" + e.CommandArgument + "' and IsActive = 1")); if (ds.Tables[0].Rows.Count > 0) { lblId.Text = e.CommandArgument.ToString(); txtTitle.Text = ds.Tables[0].Rows[0]["Title"].ToString(); txtDescription.Text = ds.Tables[0].Rows[0]["Desc"].ToString(); } } if (e.CommandName == "DeleteGroup") { cls.ExecuteDA("Delete_Newsletter", new SqlParameter("@NewsletterID", e.CommandArgument)); clearall(); lblMsg.Text = "Record Deleted Sucessfully"; BindNewsletter(); } }
protected void rptr_ItemCommand(object sender, RepeaterCommandEventArgs e) { if (e.CommandName == "Edit") { lblMsg.Text = ""; DataSet dset = new DataSet(); dset = cls.ReturnDataSet("sp_RetriveData", new SqlParameter("TblNm", "Coupon"), new SqlParameter("strwhereclause", "where ID = " + e.CommandArgument + " ")); if (dset.Tables[0].Rows.Count > 0) { DataRow dRow = null; foreach (DataRow dRow_loopVariable in dset.Tables[0].Rows) { dRow = dRow_loopVariable; txtCode.Text = dRow["CouponName"].ToString(); txtDiscount.Text = dRow["Discount"].ToString(); if (dRow["CriteriaA"].ToString() == "0") { chkCriteriaA.Checked = false; rbtCriteriaA.SelectedValue = ""; } else if (dRow["CriteriaA"].ToString() == "1") { chkCriteriaA.Checked = true; rbtCriteriaA.SelectedValue = "1"; } else { chkCriteriaA.Checked = true; rbtCriteriaA.SelectedValue = "2"; } if (dRow["CriteriaB"].ToString() == "0") { chkCriteriaB.Checked = false; rbtCriteriaB.SelectedValue = ""; } else if (dRow["CriteriaB"].ToString() == "3") { chkCriteriaB.Checked = true; rbtCriteriaB.SelectedValue = "3"; } else { chkCriteriaB.Checked = true; rbtCriteriaB.SelectedValue = "4"; } if (dRow["CriteriaC"].ToString() == "0") { chkCriteriaC.Checked = false; rbtCriteriaC.SelectedValue = ""; } else if (dRow["CriteriaC"].ToString() == "5") { chkCriteriaC.Checked = true; rbtCriteriaC.SelectedValue = "5"; } else { chkCriteriaC.Checked = true; rbtCriteriaC.SelectedValue = "6"; } chkIsActive.Checked = Convert.ToBoolean(dRow["InUse"]); lblId.Text = e.CommandArgument.ToString(); } } } else if (e.CommandName == "Delete") { cls.ExecuteDA("DeleteRecord", new SqlParameter("@TblNm", "Coupon"), new SqlParameter("@strField", "Id"), new SqlParameter("@strValue", e.CommandArgument.ToString())); BindData(); lblMsg.Text = "Record deleted successfully."; } else if (e.CommandName == "InUseYes") { cls.ExecuteDA("Update_CouponInUse", new SqlParameter("@Id", e.CommandArgument.ToString()), new SqlParameter("@InUse", true)); lblMsg.Text = "Record updated successfully"; BindData(); } else if (e.CommandName == "InUseNo") { cls.ExecuteDA("Update_CouponInUse", new SqlParameter("@Id", e.CommandArgument.ToString()), new SqlParameter("@InUse", false)); lblMsg.Text = "Record updated successfully"; BindData(); } }