public ActionResult CreateUpdateBrand(BrandManagement brand, HttpPostedFileBase file) { if (accessDetail != null && (accessDetail.access["all"] || accessDetail.access["create"])) { //if (brand.id == 0 && file == null) //{ // return Json(new { success = false, message = "Vui lòng chọn hình ảnh" }); //} if (file != null) { string LocalPath = ""; brand.logo = new AzureHelper().UploadImageToAzure(AllConstant.FoldderName_Brand, file, currentUser.name, ref LocalPath); } brand.ngay_tao = DateTime.Now; brand.nguoi_tao = currentUser.name; brand.ngay_cap_nhat = DateTime.Now; brand.nguoi_cap_nhat = currentUser.name; string rs = new BrandManagementDAO().CreateUpdate(brand, currentUser.name, AppConfigs.MCCConnectionString); if (!string.IsNullOrEmpty(rs)) { string[] StringSplit = new string[] { "@@" }; if (rs.Split(StringSplit, StringSplitOptions.None)[0] == "false") { return(Json(new { success = false, error = rs.Split(StringSplit, StringSplitOptions.None)[1] })); } using (var dbConn = MCC.Helpers.OrmliteConnection.openConn()) { var data = dbConn.FirstOrDefault <BrandManagement>("ma_thuong_hieu={0}".Params(rs.Split(StringSplit, StringSplitOptions.None)[1])); return(Json(new { success = true, data = data })); } } } return(RedirectToAction("NoAccess", "Error")); }
private void DeleteBrandButton_Click(object sender, EventArgs e) { try { if (BrandDataGridView.Rows.Count != 0) { if (MetroMessageBox.Show(this, $"¿Seguro que desea eliminar la marca: { BrandDataGridView.CurrentRow.Cells[1].Value.ToString() }?", "Eliminar Marca", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { if (BrandManagement.DeleteBrandById(int.Parse(BrandDataGridView.CurrentRow.Cells[0].Value.ToString()))) { FrmMain.Instance.ToolStripLabel.Text = "Se elimino la Marca correctamente."; BrandNameTextBox.Text = ""; ReloadBrandsDataGridView(); } else { MetroMessageBox.Show(this, $"Ha ocurrido un error al eliminar la marca: { BrandDataGridView.CurrentRow.Cells[1].Value.ToString()}.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MetroMessageBox.Show(this, "Debe seleccionar una marca para poder eliminarla.", "Campo vacío", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { } }
private void SaveBrandButton_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(BrandNameTextBox.Text)) { if (BrandManagement.SelectBrandByName(BrandNameTextBox.Text) == null) { if (BrandManagement.InsertBrand(BrandNameTextBox.Text)) { FrmMain.Instance.ToolStripLabel.Text = "Se agrego el Empleado correctamente."; BrandNameTextBox.Text = ""; ReloadBrandsDataGridView(); } else { MetroMessageBox.Show(this, $"Ha ocurrido un error al agregar la marca: { BrandNameTextBox.Text}.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MetroMessageBox.Show(this, "Ya existe una marca con ese nombre.", "Marca repetida", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MetroMessageBox.Show(this, "El campo del nombre de la marca no puede estar vacío.", "Campo vacío", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { } }
public string CreateUpdate(BrandManagement brand, string UserName, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { try { var checkID = db.SingleOrDefault <BrandManagement>("ma_thuong_hieu={0}", brand.ma_thuong_hieu); if (checkID != null) { checkID.logo = (!string.IsNullOrEmpty(brand.logo) && checkID.logo != brand.logo) ? brand.logo : checkID.logo; checkID.ten_thuong_hieu = !string.IsNullOrEmpty(brand.ten_thuong_hieu) ? brand.ten_thuong_hieu : checkID.ten_thuong_hieu; checkID.trang_thai = !string.IsNullOrEmpty(brand.trang_thai) ? brand.trang_thai : checkID.trang_thai; checkID.mo_ta = !string.IsNullOrEmpty(brand.mo_ta) ? brand.mo_ta : checkID.mo_ta; checkID.slug = StringHelper.convertToUnSign3(brand.ten_thuong_hieu); checkID.nguoi_cap_nhat = UserName; checkID.ngay_cap_nhat = DateTime.Now; db.Update(checkID); } else { var lastId = db.FirstOrDefault <BrandManagement>("SELECT TOP 1 * FROM BrandManagement ORDER BY id DESC"); if (lastId != null) { if (lastId.ma_thuong_hieu.Contains("BRA")) { var nextNo = Int32.Parse(lastId.ma_thuong_hieu.Substring(3, 10)) + 1; brand.ma_thuong_hieu = "BRA" + String.Format("{0:0000000000}", nextNo); } } else { brand.ma_thuong_hieu = "BRA" + "0000000001"; } brand.logo = !string.IsNullOrEmpty(brand.logo) ? brand.logo : ""; brand.ten_thuong_hieu = !string.IsNullOrEmpty(brand.ten_thuong_hieu) ? brand.ten_thuong_hieu : ""; brand.trang_thai = !string.IsNullOrEmpty(brand.trang_thai) ? brand.trang_thai : AllConstant.trang_thai.DANG_SU_DUNG; brand.mo_ta = !string.IsNullOrEmpty(brand.mo_ta) ? brand.mo_ta : ""; brand.slug = StringHelper.convertToUnSign3(brand.ten_thuong_hieu); brand.nguoi_tao = UserName; brand.ngay_tao = DateTime.Now; brand.nguoi_cap_nhat = UserName; brand.ngay_cap_nhat = DateTime.Now; db.Insert(brand); } //SyncToMySQL List <SqlParameter> lstParameter = new List <SqlParameter>(); lstParameter.Clear(); lstParameter.Add(new SqlParameter("@ma_thuong_hieu", brand.ma_thuong_hieu)); new SqlHelper(connectionString).ExecuteNoneQuery("p_Brand_SyncToMySQL", lstParameter); return("true@@" + brand.ma_thuong_hieu); } catch (Exception e) { return("false@@" + e.Message); } } }
public TestController() { _audit = new AuditManagement(); _user = new UserManagement(); _menu = new MenuManagement(); _role = new RoleManagement(); _client = new ClientManagement(); _brand = new BrandManagement(); }
private void SearchBrandTextBox_ButtonClick(object sender, EventArgs e) { if (!string.IsNullOrEmpty(SearchBrandTextBox.Text)) { BrandDataGridView.DataSource = BrandManagement.SelectBrandsByName(SearchBrandTextBox.Text); } else { ReloadBrandsDataGridView(); } }
public DolphinController() { _audit = new AuditManagement(); _user = new UserManagement(); _menu = new MenuManagement(); _role = new RoleManagement(); _client = new ClientManagement(); _brand = new BrandManagement(); _terminal = new TerminalManagement(); _incident = new IncidentManagement(); }
private void LoadData() { url = textBox1.Text; Crawler cr = new Crawler(); cr.LoadData(url); List <string> paths = cr.paths; main.textBoxProductName.Text = cr.title; main.pictureBoxBaseImage.Image = Bitmap.FromFile(paths[0]); main.linkLabel1.Text = paths[0];//등록후 패쓰에서는 뺀다 main.textBoxPrice.Text = cr.price; main.textBoxDiscount.Text = cr.discount; main.textBoxDiscountAmount.Text = cr.discountPrice; paths.RemoveAt(0); main.dataGridView1.Rows.Clear(); foreach (string path in paths) { main.dataGridView1.Rows.Add(path); } //브랜드를 찾아보고 없으면 등록. BrandManagement bm = new BrandManagement(mainForm.dbLoginInfo); string brandName = cr.title.Substring(cr.title.IndexOf('[') + 1, cr.title.IndexOf(']') - cr.title.IndexOf('[') - 1); int index = bm.FindBrandIndex(brandName); if (index < 1) { //브랜드를 등록한다 bm.AddBrand(brandName); //브랜드 리로드 main.comboBoxBrand.Items.Clear(); string[] brands = bm.LoadBrand(); foreach (string name in brands) { main.comboBoxBrand.Items.Add(name); } index = bm.FindBrandIndex(brandName); } var test = string.Format("{0:000}|{1}", index, brandName); main.comboBoxBrand.SelectedItem = string.Format("{0:000}|{1}", index, brandName); //카테고리는 선택만(없으면 생략) CategoryManagement cm = new CategoryManagement(mainForm.dbLoginInfo); index = cm.FindCategory(cr.category); if (index > 0) { string text = string.Format("{0:000} | {1} | {2:000}", index, cr.category, cm.FindParentIndex(index)); main.buttonCategory.Text = text; } }
//--------METODOS DE RECARGA DE DATOS DE LOS ATRIBUTOS---------------- private void ReloadBrandsDataGridView() { brandModels = BrandManagement.SelectAllBrands(); BrandDataGridView.MultiSelect = false; BrandDataGridView.DataSource = brandModels; BrandDataGridView.Columns["Id_Brand"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; BrandDataGridView.Columns["Name"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; BrandDataGridView.Columns["Id_Brand"].HeaderText = "Id"; BrandDataGridView.Columns["Name"].HeaderText = "Nombre"; BrandDataGridView.Columns["Id_Brand"].Visible = false; }
private void UcProduct_Load(object sender, EventArgs e) { categoryModels = CategoryManagement.SelectAllCategories(); subCategoryModels = SubCategoryManagement.SelectAllSubCategories(); dgvProduct.DataSource = ProductManagement.SelectAllProducts(); cmbBrand.DataSource = BrandManagement.SelectAllBrands(); cmbBrand.DisplayMember = "Name"; WireUpCategoryComboBox(); WireUpSubCategoryComboBox(); }
private List <SelectListItem> getBrandDropDownData() { BrandManagement brandManagement = new BrandManagement(); var query = from b in brandManagement.GetAllBrands() select new SelectListItem { Value = b.Brand_ID.ToString(), Text = b.Brand_Name }; return(query.ToList()); }
//Carga datos de inicio private void UcProduct_Load(object sender, EventArgs e) { ReloadProduct(); brandModels = BrandManagement.SelectAllBrands(); BrandComboBox.DataSource = brandModels; BrandComboBox.DisplayMember = "Name"; categoryModels = CategoryManagement.SelectAllCategories(); CategoryComboBox.DataSource = categoryModels; CategoryComboBox.DisplayMember = "Name"; gravadoRadioButton.Checked = true; }
private void brandTextBox_KeyUp(object sender, KeyEventArgs e) { string brand = brandTextBox.Text; if (e.KeyCode == Keys.Enter) { if (brand != " ") { foreach (BrandModel brandModel in BrandManagement.SelectBrandByName(brand)) { dgvSearchProduct.DataSource = ProductManagement.SelectProductByIdBrand(brandModel.IdBrand.ToString()); } } } }
private void ButtonEditClick(object sender, EventArgs e) { BrandEditor be = new BrandEditor(); be.ShowDialog(); //브랜드 리로드 comboBoxBrand.Items.Clear(); BrandManagement bm = new BrandManagement(dbLoginInfo); string[] brands = bm.LoadBrand(); foreach (string brandName in brands) { comboBoxBrand.Items.Add(brandName); } }
private void brandNameSearchTextBox_KeyUp(object sender, KeyEventArgs e) { try { if (!string.IsNullOrEmpty(brandNameSearchTextBox.Text)) { brandsGridView.DataSource = BrandManagement.SelectBrandByName(brandNameSearchTextBox.Text); } else { WireUpBrandsGridView(); } } catch (Exception ex) { throw; } }
private void mainForm_Load(object sender, EventArgs e) { if (Properties.Settings.Default.dbAddress == "") { InfoInsert ii = new InfoInsert(); ii.ShowDialog(); } SetServerInfo(); //브랜드 불러오기 BrandManagement bm = new BrandManagement(dbLoginInfo); string[] brands = bm.LoadBrand(); foreach (string brandName in brands) { comboBoxBrand.Items.Add(brandName); } }
private void FrmBrand_Load(object sender, EventArgs e) { try { if (BrandManagement.SelectAllBrands() != null) { brandModels = BrandManagement.SelectAllBrands(); WireUpBrandsGridView(); toolStripStatusLabel1.Text = "Los registros de la base de datos fueron cargados."; } else { toolStripStatusLabel1.Text = "No se encontraron registros en la base de datos."; } } catch (Exception ex) { throw; } }
private void deleteButton_Click(object sender, EventArgs e) { string id = idBrandTextBox.Text; try { if (BrandManagement.DeleteBrandById(id)) { Clear(); brandModels = BrandManagement.SelectAllBrands(); WireUpBrandsGridView(); toolStripStatusLabel1.Text = "Se eliminó la marca de manera correcta"; } else { toolStripStatusLabel1.Text = "Ha ocurrido un error al eliminar la marca, inténtelo nuevamente."; } } catch (Exception ex) { throw; } }
private void updateButton_Click(object sender, EventArgs e) { string id = idBrandTextBox.Text; //dgvBrand.CurrentRow.Cells[0].Value.ToString(); string brand = brandNameTextBox.Text; try { if (BrandManagement.UpdateBrandById(id, brand)) { Clear(); brandModels = BrandManagement.SelectAllBrands(); WireUpBrandsGridView(); toolStripStatusLabel1.Text = "Se modificó la marca de manera correcta."; } else { toolStripStatusLabel1.Text = "Ha ocurrido un error al modificar la marca, inténtelo nuevamente."; } } catch (Exception ex) { throw; } }
//---------CRUD---------// private void createButton_Click(object sender, EventArgs e) { string id = idBrandTextBox.Text; string brand = brandNameTextBox.Text; try { if (BrandManagement.InsertBrand(brand)) { toolStripStatusLabel1.Text = "Se agregó la marca de manera correcta."; Clear(); brandModels = BrandManagement.SelectAllBrands(); WireUpBrandsGridView(); } else { toolStripStatusLabel1.Text = "Ha ocurrido un error al agregar la marca, inténtelo nuevamente."; } } catch (Exception ex) { throw; } }
public BrandEditor() { InitializeComponent(); bm = new BrandManagement("Server=hjknas.asuscomm.com;Port=3333;Database=davala;Uid=davalaAdmin;Pwd=admin2$%"); }