public string JobCategoryAll(PropCategory objCategory) { SqlCommand cmd = new SqlCommand("proc_Category", objCon.Con); cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@Action", "DropDown"); //cmd.Parameters.AddWithValue("@status", objCategory.Flag); //cmd.Parameters.AddWithValue("@jobtypeID", objCategory.JobTypeValue); cmd.Parameters.AddWithValue("@Action", "View"); cmd.Parameters.AddWithValue("@status", objCategory.Flag); SqlDataAdapter adpt = new SqlDataAdapter(); DataSet ds = new DataSet(); if (objCon.Con.State == ConnectionState.Open) { } else { objCon.Con.Open(); } cmd.Connection = objCon.Con; adpt.SelectCommand = cmd; adpt.Fill(ds, "JobCategoriesA"); objCon.Con.Close(); return(ds.GetXml()); }
/// <summary> /// This Method is used to Select data from tbl_category table /// </summary> /// <param name="objCategory">Action</param> /// <returns>1 for success and -1 for fail</returns> public string SelectCategory(PropCategory objCategory, string userName) { if (userName != null && userName != "") { SqlCommand cmd = new SqlCommand("proc_Category", objCon.Con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", "View"); cmd.Parameters.AddWithValue("@status", objCategory.Flag); SqlDataAdapter adpt = new SqlDataAdapter(); DataSet ds = new DataSet(); if (objCon.Con.State == ConnectionState.Open) { } else { objCon.Con.Open(); } cmd.Connection = objCon.Con; adpt.SelectCommand = cmd; adpt.Fill(ds, "Categories"); objCon.Con.Close(); return(ds.GetXml()); } else { return("Not Valid"); } }
/// <summary> /// This method will get associate Purchased Categories on the basis of jobtype /// </summary> /// <param name="objCategory"></param> /// <param name="userName"></param> /// <returns></returns> public string AssociatePurchasedCategory(PropCategory objCategory, string userName) { if (userName != null && userName != "") { SqlCommand cmd = new SqlCommand("proc_AllAssociateCategories", objCon.Con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", "PurchasedCat"); cmd.Parameters.AddWithValue("@associateID", Convert.ToInt32(userName)); cmd.Parameters.AddWithValue("@jobType", objCategory.JobTypeValue); SqlDataAdapter adpt = new SqlDataAdapter(); DataSet ds = new DataSet(); if (objCon.Con.State == ConnectionState.Open) { } else { objCon.Con.Open(); } cmd.Connection = objCon.Con; adpt.SelectCommand = cmd; adpt.Fill(ds, "AssociateCategories"); objCon.Con.Close(); return(ds.GetXml()); } else { return("Not Valid"); } }
/// <summary> /// This Method is used to Delete data into tbl_category table /// </summary> /// <param name="objCategory">ID and Action</param> /// <returns>1 for success and -1 for fail</returns> public string DeleteCategory(PropCategory objCategory, string userName) { if (userName != null && userName != "") { SqlCommand cmd = new SqlCommand("proc_Category", objCon.Con); cmd.CommandType = CommandType.StoredProcedure; objCon.Con.Open(); try { cmd.Parameters.AddWithValue("@ID", objCategory.IdValue); cmd.Parameters.AddWithValue("@Action", "Delete"); return(cmd.ExecuteNonQuery().ToString()); } catch (Exception showError) { throw showError; } finally { cmd.Dispose(); objCon.Con.Close(); objCon.Con.Dispose(); } } else { return("Not Valid"); } }
protected void grdvViewPurchaseOrder_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow && grdvViewPurchaseOrder.EditIndex == e.Row.RowIndex) { PropCategory objcat = new PropCategory(); DropDownList dd2 = (DropDownList)e.Row.FindControl("drpEditCategory"); dd2.DataSource = BusinessNewPurchase.busSelectCategory(objcat); dd2.DataBind(); PropSubCategory objsub = new PropSubCategory(); DropDownList dd3 = (DropDownList)e.Row.FindControl("drpEditSubCategory"); dd3.DataSource = BusinessNewPurchase.busSelectSubCategoryGridview(objsub); dd3.DataBind(); //propunit objUnit = new propunit(); //DropDownList dd4 = (DropDownList)e.Row.FindControl("ddlUnit"); //dd4.DataSource = BusinessNewPurchase.busSelectUnit(objUnit); //dd4.DataBind(); PropSubSubCategory objsubsubsub = new PropSubSubCategory(); DropDownList dd5 = (DropDownList)e.Row.FindControl("drpEditSubSubCategory"); dd5.DataSource = BusinessNewPurchase.buseditmodefillsubcat(objsubsubsub); dd5.DataBind(); } }
public string ViewSearchingCategories(int jobtype, string zipcode, string _action) { string str = string.Empty; BllSearchingCategories objInnerpage = new BllSearchingCategories(); PropCategory objProperty = new PropCategory(); objProperty.JobTypeValue = jobtype; str = objInnerpage.SearchSalesCategory(objProperty, zipcode, _action); return(str); }
public string AssociatePurchasedCategory(int jobtype) { string str = string.Empty; PropCategory propCategory = new PropCategory(); propCategory.JobTypeValue = jobtype; BllJobCategory objCategory = new BllJobCategory(); str = objCategory.AssociatePurchasedCategory(propCategory, Session["associate"].ToString()); return(str); }
public string AllJobtypeWiseCategory(int flag) { string str = string.Empty; PropCategory propCategory = new PropCategory(); propCategory.Flag = flag; BllJobCategory objCategory = new BllJobCategory(); str = objCategory.AllJobCategory(propCategory); return(str); }
public string JobtypeWiseCategory(int flag, int jobtype) { string str = string.Empty; PropCategory propCategory = new PropCategory(); propCategory.Flag = flag; propCategory.JobTypeValue = jobtype; BllJobCategory objCategory = new BllJobCategory(); str = objCategory.JobCategory(propCategory); return(str); }
public string SelectCategory(int flag) { string str = string.Empty; if (Session["admin"].ToString() != "" || Session["admin"].ToString() != null) { PropCategory propCategory = new PropCategory(); propCategory.Flag = flag; BllJobCategory objCategory = new BllJobCategory(); str = objCategory.RecordSelect(propCategory, Session["admin"].ToString()); return(str); } else { return("Error in Authentication"); } }
/// <summary> /// This Method is used to Select data /// </summary> /// <param name="objCategory">Action</param> /// <returns>1 for success and -1 for fail</returns> public string RecordSelect(PropCategory objProperty, string UserName) { DllJobCategory objDal = new DllJobCategory(); try { return(objDal.SelectCategory(objProperty, UserName)); } catch (Exception info) { throw info; } finally { objDal = null; } }
public string SearchSalesCategory(PropCategory objProperty, string zipcode, string _action) { DllSearchingCategories objDal = new DllSearchingCategories(); try { return(objDal.SearchSalesCategory(objProperty, zipcode, _action)); } catch (Exception info) { throw info; } finally { objDal = null; } }
/// <summary> /// This method will get associate Purchased Categories on the basis of jobtype /// </summary> /// <param name="objProperty"></param> /// <param name="UserName"></param> /// <returns></returns> public string AssociatePurchasedCategory(PropCategory objProperty, string UserName) { DllJobCategory objDal = new DllJobCategory(); try { return(objDal.AssociatePurchasedCategory(objProperty, UserName)); } catch (Exception info) { throw info; } finally { objDal = null; } }
public string AllJobCategory(PropCategory objProperty) { DllJobCategory objDal = new DllJobCategory(); try { return(objDal.JobCategoryAll(objProperty)); } catch (Exception info) { throw info; } finally { objDal = null; } }
protected void ddlCategory_SelectedIndexChanged(object sender, EventArgs e) { if (ddlCategory.SelectedIndex != 0) { ddlSubCat.Items.Clear(); ddlSubSubCat.Items.Clear(); ddlSubCat.Items.Add("-Select-"); PropCategory obj = new PropCategory(); obj.Id = Convert.ToInt32(ddlCategory.SelectedItem.Value.ToString()); ddlSubCat.DataSource = BusinessNewPurchase.busSelectSubCategory(obj); ddlSubCat.DataBind(); } else { ddlSubCat.Items.Clear(); ddlSubCat.Items.Add("-Select-"); } }
protected void btnSubmitCat_Click(object sender, EventArgs e) { PropCategory newcat = new PropCategory(); newcat.Name = txtPopCatName.Text; int op = BusinessNewPurchase.buspopCategory(newcat); if (op <= 0) { ClientScript.RegisterStartupScript(Page.GetType(), "test3", "<script>window.opener.location.reload(true);window.close();</script>"); } else { Response.Write("Error in processing.Please Try Again!!"); } }
public string UpdateCategory(string Name, int ID) { string str = string.Empty; if (Session["admin"] != "" || Session["admin"].ToString() != null) { PropCategory propCategory = new PropCategory(); propCategory.CategoryNameValue = Name; propCategory.IdValue = ID; BllJobCategory objCategory = new BllJobCategory(); str = objCategory.RecordUpdate(propCategory, Session["admin"].ToString()); return(str); } else { return("Error in Authentication"); } }
public string InsertCategory(int jobType, string CategoryName) { string str = string.Empty; if (Session["admin"].ToString() != "" || Session["admin"].ToString() != null) { PropCategory propcat = new PropCategory(); propcat.CategoryNameValue = CategoryName; propcat.JobTypeValue = jobType; // propcat.CategoryImage = CateImage; BllJobCategory objCategory = new BllJobCategory(); str = objCategory.RecordInsert(propcat, Session["admin"].ToString()); return(str); } else { return("Error in Authentication"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["data"] != null)//session checking { if (!IsPostBack) { PropItem objItem = new PropItem(); ddlItemName.DataSource = BusinessNewPurchase.busSelectItem(objItem); ddlItemName.DataBind();//data binding PropCategory objcat = new PropCategory(); ddlCategory.DataSource = BusinessNewPurchase.busSelectCategory(objcat); ddlCategory.DataBind(); PropVendor objVendor = new PropVendor(); ddlSupplierName.DataSource = BusinessNewPurchase.busSelectVendor(objVendor); ddlSupplierName.DataBind(); PropDestination objDes = new PropDestination(); DdlSite.DataSource = BusinessNewPurchase.busFillDestination(objDes); DdlSite.DataBind(); //propunit objUnit = new propunit(); //drplUnit.DataSource = BusinessNewPurchase.busSelectUnit(objUnit); //drplUnit.DataBind(); addItem.Attributes.Add("onclick", "openPopUp('PopUpItem.aspx')"); AddVendor.Attributes.Add("onclick", "openPopUpVendor('PopUpVendor.aspx')"); } Label1.Text = ""; } else { Response.Redirect("~/Login.aspx");//page redirection } }
protected void Page_Load(object sender, EventArgs e) { if (Session["data"] != null)//session checking { if (!IsPostBack) { PropItem objItem = new PropItem(); ddlSearchItemName.DataSource = BusinessNewPurchase.busSelectItem(objItem); ddlSearchItemName.DataBind(); PropCategory objcat = new PropCategory(); ddlCategory.DataSource = BusinessNewPurchase.busSelectCategory(objcat); ddlCategory.DataBind(); PropVendor objVendor = new PropVendor(); ddlSearchVenderName.DataSource = BusinessNewPurchase.busSelectVendor(objVendor); ddlSearchVenderName.DataBind(); } } else { Response.Redirect("~/Login.aspx"); } }
public string SearchSalesCategory(PropCategory objCategory, string zipcode, string _action) { SqlCommand cmd = new SqlCommand("proc_GetSearchingCategory", objCon.Con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", _action); cmd.Parameters.AddWithValue("@jobType", objCategory.JobTypeValue); cmd.Parameters.AddWithValue("@zipCode", zipcode); SqlDataAdapter adpt = new SqlDataAdapter(); DataSet ds = new DataSet(); if (objCon.Con.State == ConnectionState.Open) { } else { objCon.Con.Open(); } cmd.Connection = objCon.Con; adpt.SelectCommand = cmd; adpt.Fill(ds, "SearchCategories"); objCon.Con.Close(); return(ds.GetXml()); }
public static DataSet searchbycategory(PropCategory obj4) { return(DBManager.ExecuteDataset("spSelectCategory", obj4.Name)); }
public static DataSet selectSubCategory(PropCategory objsub) { return(DBManager.ExecuteDataset("spFillSubCategory", objsub.Id)); }
public static DataSet busSelectSubCategory(PropCategory objSub) { return(DalItemPurchase.selectSubCategory(objSub)); }
public static int buspopCategory(PropCategory objCategory) { return(DalItemPurchase.InsertpopCategory(objCategory)); }
public PropCategory(PropCategory elementType) { Value = elementType.Value; }
public static DataSet busSearchCategory(PropCategory obj5) { return(DalSearching.searchbycategory(obj5)); }
public static int InsertpopCategory(PropCategory objcat) { return(DBManager.ExecuteNonQuery("spPopInserCategoryName", objcat.Name)); }