public void InsertBrand(string name, string description)
{
try
{
name = name.TrimEnd().TrimStart();
description = description.TrimEnd().TrimStart();
}
catch (Exception)
{
throw new Exception("No es posible registrar la Marca");
}
BrandsDAO dao = new BrandsDAO();
List <Brand> brands = GetAllBrands();
if (brands.FindAll(b => b.name.ToUpperInvariant().Equals(name.ToUpperInvariant())).Count > 0)
{
throw new Exception("Ya existe una Marca con este nombre");
}
Brand newBrand = new Brand();
newBrand.name = name;
newBrand.description = description;
int result = dao.CreateBrand(newBrand);
if (result < 1)
{
throw new Exception("No es posible registrar la Marca");
}
}
public List <Brand> GetAllBrands()
{
List <Brand> brands = new List <Brand>();
BrandsDAO dao = new BrandsDAO();
brands = dao.GetAllBrands();
return(brands);
}
private void ListBrands()
{
BrandsDAO brandsDAO = new BrandsDAO();
var brands = brandsDAO.Listagem();
List <SelectListItem> brandsList = new List <SelectListItem>();
brandsList.Add(new SelectListItem("Selecione uma marca", "0"));
foreach (var brand in brands)
{
SelectListItem item = new SelectListItem(brand.Name, brand.Id.ToString());
brandsList.Add(item);
}
ViewBag.Brands = brandsList;
}
public void DeleteBrand(int id)
{
BrandsDAO dao = new BrandsDAO();
Brand deleteBrand = dao.GetBrand(id);
if (deleteBrand != null)
{
int result = dao.DeleteBrand(deleteBrand);
if (result < 1)
{
throw new Exception("No es posible eliminar la Marca, por favor verificar que no existen Productos asociados a la Marca");
}
}
else
{
throw new Exception("El id de la Marca a actualizar no es válido");
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
Brand objBrand = new Brand();
DataSet ds;
objBrand.BrandName = txtBrandName.Text.Trim();
if (objBrand.BrandName != String.Empty)
{
objBrand.SearchBrands();
ds = objBrand.DsCategories;
}
else
{
ds = new BrandsDAO().GetAllBrands();
}
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
gvBrands.DataSource = ds;
gvBrands.DataBind();
trGrid.Visible = true;
trNoRecords.Visible = false;
}
else
{
trNoRecords.Visible = true;
trGrid.Visible = false;
}
}
catch (Exception ex)
{
ex.Data.Add("UILayerException", this.GetType().ToString() + Constant.Error_Seperator + "protected void btnSearch_Click(object sender, EventArgs e)");
if (Master.LoggedUser != null && Master.LoggedUser.UserName != null && Master.LoggedUser.UserName != string.Empty)
{
Response.Redirect("Error.aspx?LogId=" + LankaTilesExceptions.WriteEventLogs(ex, Constant.Database_Connection_Name, Master.LoggedUser.UserName), false);
}
else
{
Response.Redirect("Error.aspx?LogId=" + LankaTilesExceptions.WriteEventLogs(ex, Constant.Database_Connection_Name, "Annonimous"), false);
}
}
}
public void UpdateBrand(int id, string name, string description)
{
try
{
name = name.TrimEnd().TrimStart();
description = description.TrimEnd().TrimStart();
}
catch (Exception)
{
throw new Exception("No es posible actualizar la Marca");
}
BrandsDAO dao = new BrandsDAO();
//Brand updateBrand = dao.GetBrand(id);
List <Brand> brands = GetAllBrands();
Brand updateBrand = brands.Find(b => b.id.Equals(id));
if (updateBrand != null)
{
if (brands.FindAll(b => (b.name.Equals(name.ToUpperInvariant())) && (b.id != id)).Count > 0)
{
throw new Exception("Ya existe una Marca con este nombre");
}
updateBrand.name = name;
updateBrand.description = description;
int result = dao.UpdateBrand(updateBrand);
if (result < 1)
{
throw new Exception("No es posible actualizar la Marca");
}
}
else
{
throw new Exception("El id de la Marca a actualizar no es válido");
}
}
public void LoadInitialData()
{
try
{
//
// category
//
DataSet dsCategory = (new CategoryDAO()).GetAllCategories();
if (dsCategory == null || dsCategory.Tables.Count == 0)
{
ddlCatCode.Items.Add(new ListItem("--No Data Found--", "-1"));
}
else
{
Master.BindDropdown("CategoryType", "CategoryId", dsCategory, ddlCatCode);
ddlCatCode.Items.Add(new ListItem("--Please Select--", "-1"));
ddlCatCode.SelectedValue = "-1";
}
//
// Brand
//
DataSet dsBrands = new BrandsDAO().GetAllBrands();
if (dsBrands == null || dsBrands.Tables.Count == 0)
{
ddlBrandCode.Items.Add(new ListItem("--No Data Found--", "-1"));
}
else
{
Master.BindDropdown("BrandName", "BrandId", dsBrands, ddlBrandCode);
ddlBrandCode.Items.Add(new ListItem("--Please Select--", "-1"));
ddlBrandCode.SelectedValue = "-1";
}
//
// Status
//
ListItem[] status = { new ListItem("--Please Select--", "-1"), new ListItem("Active", "1"), new ListItem("InActive", "0") };
ddlStatus.Items.AddRange(status);
ddlStatus.SelectedValue = "1";
//
// Types
//
DataSet dsTypes = (new TypesDAO()).GetAllTypes();
if (dsTypes == null || dsTypes.Tables.Count == 0)
{
ddlType.Items.Add(new ListItem("--No Data Found--", "-1"));
}
else
{
Master.BindDropdown("TypeName", "TypeId", dsTypes, ddlType);
ddlType.Items.Add(new ListItem("--Please Select--", "-1"));
ddlType.SelectedValue = "-1";
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Fill the default details for the controls
/// </summary>
public void LoadInitialData()
{
try
{
//
// category
//
DataSet dsCategory = (new CategoryDAO()).GetAllCategories();
if (dsCategory == null || dsCategory.Tables.Count == 0)
{
ddlCategory.Items.Add(new ListItem("--No Data Found--", "-1"));
}
else
{
Master.BindDropdown("CategoryType", "CategoryId", dsCategory, ddlCategory);
ddlCategory.Items.Add(new ListItem("All", "-1"));
ddlCategory.SelectedValue = "-1";
}
//
// Add Branch
//
DataSet dsRoles = (new LocationsDAO()).GetAllBranches();
if (dsRoles == null || dsRoles.Tables.Count == 0)
{
ddlBranch.Items.Add(new ListEditItem("--No Records--", "-1"));
}
else
{
//Master.BindDropdown("BranchCode", "BranchId", dsRoles, ddlBranch);
ddlBranch.DataSource = dsRoles;
ddlBranch.TextField = "BranchCode";
ddlBranch.ValueField = "BranchId";
ddlBranch.DataBind();
ddlBranch.Items.Add(new ListEditItem("All", "-1"));
ddlBranch.SelectedIndex = ddlBranch.Items.FindByValue(-1).Index;
//ddlBranch.SelectedItem.Value = -1;
}
//
// Suppliers
//
DataSet dsSuppliers = (new SupplierDAO()).GetAllSuppliers();
if (dsSuppliers == null || dsSuppliers.Tables.Count == 0)
{
ddlSupplier.Items.Add(new ListItem("--No Records--", "-1"));
}
else
{
Master.BindDropdown("Sup_Code", "SupId", dsSuppliers, ddlSupplier);
ddlSupplier.Items.Add(new ListItem("All", "-1"));
ddlSupplier.SelectedValue = "-1";
}
//
// Brand
//
DataSet dsBrands = new BrandsDAO().GetAllBrands();
if (dsBrands == null || dsBrands.Tables.Count == 0)
{
ddlBrands.Items.Add(new ListItem("--No Data Found--", "-1"));
}
else
{
Master.BindDropdown("BrandName", "BrandId", dsBrands, ddlBrands);
ddlBrands.Items.Add(new ListItem("All", "-1"));
ddlBrands.SelectedValue = "-1";
}
//
// Status
//
ListItem[] status = { new ListItem("All", "-1"), new ListItem("Active", "1"), new ListItem("InActive", "0") };
ddlStatus.Items.AddRange(status);
}
catch (Exception ex)
{
ex.Data.Add("UILayerException", this.GetType().ToString() + Constant.Error_Seperator + "public void LoadInitialData()");
if (Master.LoggedUser != null && Master.LoggedUser.UserName != null && Master.LoggedUser.UserName != string.Empty)
{
Response.Redirect("Error.aspx?LogId=" + LankaTilesExceptions.WriteEventLogs(ex, Constant.Database_Connection_Name, Master.LoggedUser.UserName), false);
}
else
{
Response.Redirect("Error.aspx?LogId=" + LankaTilesExceptions.WriteEventLogs(ex, Constant.Database_Connection_Name, "Annonimous"), false);
}
}
}
public BrandController()
{
DAO = new BrandsDAO();
GeraProximoId = true;
}
