private void btn_Category_Reset_Click(object sender, RoutedEventArgs e) { textBox_Category_ID.Text = Category_BL.GetAutogeneratedCategoryID_BL().ToString(); textBox_SearchCategory.Clear(); textBox_Category_Name.Clear(); textBox_Category_Description.Clear(); }
private void btn_Category_Search_Click(object sender, RoutedEventArgs e) { try { int catId = Convert.ToInt32(textBox_SearchCategory.Text); DataTable sEd = Category_BL.SearchCategoryById_BL(catId); DataRow dr = sEd.Rows[0]; if (!dr.IsNull("Category_Id")) { textBox_Category_ID.Text = dr["Category_Id"].ToString(); textBox_Category_Name.Text = dr["Category_Name"].ToString(); textBox_Category_Description.Text = dr["Category_Description"].ToString(); } else { MessageBox.Show("No Records found with Category Id : " + catId); } } catch (HRMSException ex) { MessageBox.Show(ex.Message); } catch (SqlException ex) { MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btn_Category_Delete_Click(object sender, RoutedEventArgs e) { try { int catId = Convert.ToInt32(textBox_SearchCategory.Text); int rowsAffected = Category_BL.DeleteCategory_BL(catId); if (rowsAffected > 0) { MessageBox.Show("Category Details Deleted !!"); } else { MessageBox.Show("Error!!! Category Record not found"); } } catch (HRMSException ex) { MessageBox.Show(ex.Message); } catch (SqlException ex) { MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btn_Category_Update_Click(object sender, RoutedEventArgs e) { try { Category newCat = new Category(); newCat.CategoryId = Convert.ToInt32(textBox_Category_ID.Text); newCat.CategoryName = textBox_Category_Name.Text; newCat.CategoryDescription = textBox_Category_Description.Text; int rowsAffected = Category_BL.UpdateCategory_BL(newCat); if (rowsAffected > 0) { MessageBox.Show("Category Updated !!"); } else { MessageBox.Show("Error!!! Category Record not Updated"); } } catch (HRMSException ex) { MessageBox.Show(ex.Message); } catch (SqlException ex) { MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
// // GET: /ModuleProduct/Category/ public ActionResult CategorysList() { try { string _url = Request.RawUrl; string _ok = CommonFunc.Nvs_Redirect_QuyenTruyCapUser(_url); if (_ok != "") { return(Redirect(_ok)); } int fromRow = 0; string htmlPaging = ""; Category_BL _Category_BL = new Category_BL(); List <Categories_Info> _lst_data = _Category_BL.Category_GetAll(); List <Categories_Info> lstDataBreakPage = NaviCommon.CommonFuc.GetPaging <Categories_Info>(_lst_data, 1, ref fromRow, ref htmlPaging, "Loại sản phẩm"); ViewBag.Paging = htmlPaging; ViewBag.FromRow = fromRow; ViewBag.Obj = lstDataBreakPage; ViewBag.SumRecord = _lst_data.Count; return(View()); } catch (Exception ex) { NaviCommon.Common.log.Error(ex.ToString()); ViewBag.FromRow = 0; return(View(new List <Categories_Info>())); } }
public string M_Category_ExistsCheck([FromBody] CategoryModel cmodel) { if (cmodel == null) { cmodel = new CategoryModel(); } Category_BL Cbl = new Category_BL(); return(Cbl.M_Category_ExistsCheck(cmodel)); }
public ActionResult ShowViewCategory(decimal p_id) { try { Category_BL _Category_BL = new Category_BL(); Categories_Info _Categories_Info = _Category_BL.Category_GetById(p_id); ViewBag.obj = _Categories_Info; return(PartialView("~/Areas/ModuleProduct/Views/Category/P_View_Category.cshtml")); } catch (Exception ex) { NaviCommon.Common.log.Error(ex.ToString()); return(PartialView("P_View_Category")); } }
public ActionResult ShowInsertProduct() { try { Category_BL _Category_BL = new Category_BL(); List <Categories_Info> _lst = _Category_BL.Category_GetAll(); ViewBag.LstCategory = _lst; return(PartialView("~/Areas/ModuleProduct/Views/Product/_Partial_Insert_Product.cshtml")); } catch (Exception ex) { NaviCommon.Common.log.Error(ex.ToString()); return(null); } }
private void btn_Category_Display_Click(object sender, RoutedEventArgs e) { try { DataTable dtCat = Category_BL.DisplayCategory_BL(); dg_Category_Details.ItemsSource = dtCat.DefaultView; } catch (HRMSException ex) { MessageBox.Show(ex.Message); } catch (SqlException ex) { MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public ActionResult DeleteCategory(decimal p_category_id) { try { // Kiểm tra có phiên làm việc không var objUser = SessionData.CurrentUser as User_Info; if (objUser == null) { // thoát đăng nhập return(Json(new { success = -1 })); } Category_BL _Category_BL = new Category_BL(); decimal _kq = _Category_BL.Category_Delete(p_category_id); return(Json(new { success = _kq })); } catch (Exception ex) { NaviCommon.Common.log.Error(ex.ToString()); return(Json(new { success = -1 })); } }
public ActionResult SearchCategory(string p_name) { try { int fromRow = 0; string htmlPaging = ""; Category_BL _Category_BL = new Category_BL(); List <Categories_Info> _lst_data = _Category_BL.Category_Search(p_name); List <Categories_Info> lstDataBreakPage = NaviCommon.CommonFuc.GetPaging <Categories_Info>(_lst_data, 1, ref fromRow, ref htmlPaging, "Loại sản phẩm"); ViewBag.Paging = htmlPaging; ViewBag.FromRow = fromRow; ViewBag.Obj = lstDataBreakPage; ViewBag.SumRecord = _lst_data.Count; return(PartialView("PartialViewTableslistCategory")); } catch (Exception ex) { NaviCommon.Common.log.Error(ex.ToString()); return(PartialView("PartialViewTableslistCategory")); } }
public ActionResult Category_Insert(string p_Category_code, string p_Category_name, string p_unit) { try { // Kiểm tra có phiên làm việc không var objUser = SessionData.CurrentUser as User_Info; if (objUser == null) { // thoát đăng nhập return(Json(new { success = -1 })); } Category_BL _Category_BL = new Category_BL(); if (_Category_BL.Category_GetByCode(p_Category_code) != null) { return(Json(new { success = -2 })); } else { bool _kq = _Category_BL.Category_Insert(p_Category_code, p_Category_name, p_unit); if (_kq) { return(Json(new { success = 0 })); } else { return(Json(new { success = -1 })); } } } catch (Exception ex) { NaviCommon.Common.log.Error(ex.ToString()); return(Json(new { success = -1 })); } }
public string Get_CategoryType([FromBody] CategoryModel Cmodel) { Category_BL Cbl = new Category_BL(); return(Cbl.Get_CategoryType(Cmodel)); }
public string Category_CUD([FromBody] CategoryModel bmodel) { Category_BL Cbl = new Category_BL(); return(Cbl.Category_CUD(bmodel)); }
public string M_Category_Select([FromBody] CategoryModel Cmodel) { Category_BL Cbl = new Category_BL(); return(Cbl.M_Category_Select(Cmodel)); }
//OnLoad Event private void Window_Loaded(object sender, RoutedEventArgs e) { textBox_Employee_Id.Text = EmployeeValidation.GetAutogeneratedEmployeeID_BL().ToString(); textBox_Project_ID.Text = Project_BL.GetAutogeneratedProjectID_BL().ToString(); textBox_Category_ID.Text = Category_BL.GetAutogeneratedCategoryID_BL().ToString(); textBox_Skill_ID.Text = Skill_BL.GetAutogeneratedSkillID_BL().ToString(); //Load Civil Status Data from Database DataTable dtCivil = EmployeeValidation.LoadCivilStatus_BL(); if (dtCivil.Rows.Count >= 0) { cmb_Employee_CivilStatus.ItemsSource = dtCivil.DefaultView; cmb_Employee_CivilStatus.DisplayMemberPath = "Status_Description"; cmb_Employee_CivilStatus.SelectedValuePath = "Status_Id"; } //Load Level Data from Database DataTable dtLvl = EmployeeValidation.LoadLevel_BL(); if (dtLvl.Rows.Count >= 0) { cmb_Employee_LevelID.ItemsSource = dtLvl.DefaultView; cmb_Employee_LevelID.DisplayMemberPath = "Level_Description"; cmb_Employee_LevelID.SelectedValuePath = "Level_Id"; } //Load Projects Data from Database DataTable dtProj = EmployeeValidation.LoadProject_BL(); if (dtProj.Rows.Count >= 0) { cmb_Employee_ProjectID.ItemsSource = dtProj.DefaultView; cmb_Employee_ProjectID.DisplayMemberPath = "Project_Name"; cmb_Employee_ProjectID.SelectedValuePath = "Project_Id"; } //Load Speciality Data from Database DataTable dtSpec = EmployeeValidation.LoadSeciality_BL(); if (dtSpec.Rows.Count >= 0) { cmb_Employee_Speciality.ItemsSource = dtSpec.DefaultView; cmb_Employee_Speciality.DisplayMemberPath = "Speciality_Name"; cmb_Employee_Speciality.SelectedValuePath = "Speciality_Id"; } //Load Skills Data from Database DataTable dtSkill = EmployeeValidation.LoadSkill_BL(); if (dtSkill.Rows.Count >= 0) { cmb_Employee_SkillID.ItemsSource = dtSkill.DefaultView; cmb_Employee_SkillID.DisplayMemberPath = "Skill_Name"; cmb_Employee_SkillID.SelectedValuePath = "Skill_Id"; } //Load Category Data from Database DataTable dtCat = Skill_BL.LoadCatSkill_BL(); if (dtCat.Rows.Count >= 0) { cmb_Category_ID.ItemsSource = dtCat.DefaultView; cmb_Category_ID.DisplayMemberPath = "Category_Name"; cmb_Category_ID.SelectedValuePath = "Category_Id"; } }