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