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$%");
}
