/// <summary>
///
/// </summary>
/// <param name="brand"></param>
/// <returns></returns>
public Int32 UpdateBrand(Entities.Brand brand)
{
var brandId = 0;
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.UpdateBrand))
{
database.AddInParameter(dbCommand, "@brand_id", DbType.Int32, brand.BrandId);
database.AddInParameter(dbCommand, "@brand_name", DbType.String, brand.BrandName);
database.AddInParameter(dbCommand, "@modified_by", DbType.Int32, brand.ModifiedBy);
database.AddInParameter(dbCommand, "@modified_by_ip", DbType.String, brand.ModifiedByIP);
database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0);
brandId = database.ExecuteNonQuery(dbCommand);
if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value)
{
brandId = Convert.ToInt32(database.GetParameterValue(dbCommand, "@return_value"));
}
}
}
catch (Exception e)
{
throw e;
}
return(brandId);
}
/// <summary>
///
/// </summary>
/// <param name="brand"></param>
/// <returns></returns>
public bool DeleteBrand(Entities.Brand brand)
{
var isDeleted = false;
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.DeleteBrand))
{
database.AddInParameter(dbCommand, "@brand_id", DbType.Int32, brand.BrandId);
database.AddInParameter(dbCommand, "@deleted_by", DbType.Int32, brand.DeletedBy);
database.AddInParameter(dbCommand, "@deleted_by_ip", DbType.String, brand.DeletedByIP);
database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0);
var result = database.ExecuteNonQuery(dbCommand);
if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value)
{
isDeleted = Convert.ToBoolean(database.GetParameterValue(dbCommand, "@return_value"));
}
}
}
catch (Exception e)
{
throw e;
}
return(isDeleted);
}
/// <summary>
///
/// </summary>
/// <param name="brandName"></param>
/// <returns></returns>
public Entities.Brand GetBrandDetailsByName(string brandName)
{
var brand = new Entities.Brand();
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetBrandDetailsByName))
{
database.AddInParameter(dbCommand, "@brand_name", DbType.String, brandName);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var _brand = new Entities.Brand
{
BrandId = DRE.GetNullableInt32(reader, "brand_id", 0),
BrandName = DRE.GetNullableString(reader, "brand_name", null),
guid = DRE.GetNullableGuid(reader, "row_guid", null)
};
brand = _brand;
}
}
}
return(brand);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Entities.Brand> GetAllBrands()
{
var brands = new List <Entities.Brand>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetListOfAllBrands))
{
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var brand = new Entities.Brand
{
BrandId = DRE.GetNullableInt32(reader, "brand_id", 0),
BrandName = DRE.GetNullableString(reader, "brand_name", null),
guid = DRE.GetNullableGuid(reader, "row_guid", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
};
brands.Add(brand);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(brands);
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
switch (_entityState)
{
case EntityState.New:
new BusinessLayer.BrandService().Add(new Entities.Brand {
BrandName = txtName.Text, Description = txtComment.Text
});
break;
case EntityState.Dirty:
Entities.Brand brand = new Entities.Brand {
BrandID = BrandID, BrandName = txtName.Text, Description = txtComment.Text
};
new BusinessLayer.GenericService <Entities.Brand>().Update(brand, b => b.BrandID == brand.BrandID);
break;
default:
break;
}
Helper.ClearForm(this);
btnSave.Text = "Save";
_entityState = EntityState.New;
Helper.ShowMessage("Brand saved successfully", "Brand Saved", MessageBoxButtons.OK, MessageBoxIcon.Information);
frmSetupDetails frmSetup = Helper.CreateInstanceFor <frmSetupDetails>("frmSetupDetails");
if (frmSetup != null)
{
frmSetup.LoadGridWithDataDatasource(() => new BusinessLayer.GenericService <Entities.Brand>().GetAll());
}
}
catch (Exception ex)
{
_logger.LogError(ex, "An error occurred", "frmAddBrand", "btnSave");
Helper.ShowMessage("Brand was not saved successfully \n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
///
/// </summary>
/// <param name="brand"></param>
/// <returns></returns>
public Int32 SaveBrand(Entities.Brand brand)
{
var brandId = 0;
if (brand.BrandId == null || brand.BrandId == 0)
{
brandId = AddBrand(brand);
}
else if (brand.ModifiedBy != null || brand.ModifiedBy > 0)
{
brandId = UpdateBrand(brand);
}
else if (brand.IsDeleted == true)
{
var result = DeleteBrand(brand);
if (result == true)
{
brandId = (int)brand.BrandId;
}
}
return(brandId);
}
public Int32 SaveBrand(Entities.Brand brand)
{
return(_brand.SaveBrand(brand));
}
public Int32 UpdateBrand(Entities.Brand brand)
{
return(_brand.UpdateBrand(brand));
}
public bool DeleteBrand(Entities.Brand brand)
{
return(_brand.DeleteBrand(brand));
}
public Int32 AddBrand(Entities.Brand brand)
{
return(_brand.AddBrand(brand));
}
