public ActionResult Edit(int id, tbl_Brands obj, HttpPostedFileBase image)
{
try
{
string imgpath = string.Empty;
if (image != null)
{
string filename = Path.GetFileName(image.FileName);
imgpath = Path.Combine(Server.MapPath("~/Images"), Path.GetFileName(image.FileName));
image.SaveAs(imgpath);
imgpath = filename;
}
obj.Brandimage = imgpath;
ViewBag.FileStatus = "YES";
// TODO: Add update logic here
db.Sp_Brands_update(obj.BrandID, obj.CategoriesID, obj.BrandName, obj.Brandimage);
return(RedirectToAction("List"));
}
catch
{
return(View());
}
}
public BrandModel UpdateBrand(BrandModel _objdata)
{
tbl_Brands _objBrand = new tbl_Brands();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var _query = dataContext.tbl_Brands.Where(x => x.int_id == _objdata.intBrandId).FirstOrDefault();
if (_query != null)
{
tbl_Brands _log = new tbl_Brands();
_log = dataContext.tbl_Brands.Where(x => x.int_id == _objdata.intBrandId).FirstOrDefault();
_log.v_name = _objdata.strBrandName;
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
}
_objdata.StatusMessaage = "Brand updated sucessfully.";
return(_objdata);
}
}
catch (Exception)
{
throw;
}
}
public BrandModel DeleteBrand(int intBrandId)
{
BrandModel _objdata = new BrandModel();
tbl_Brands _objBrand = new tbl_Brands();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var _query = dataContext.tbl_Brands.Where(x => x.int_id == intBrandId).FirstOrDefault();
if (_query != null)
{
tbl_Brands _log = new tbl_Brands();
_log = dataContext.tbl_Brands.Where(x => x.int_id == intBrandId).FirstOrDefault();
// _log.b_IsActive = false;
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
}
_objdata.StatusMessaage = "Brand deleted sucessfully.";
return(_objdata);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveBrand(string id, string name, string status)
{
InventoryBL bl = new InventoryBL();
tbl_Brands brand = new tbl_Brands()
{
Brand_Id = Convert.ToInt32(id),
Brand_Name = name,
Brand_Status = status == "1" ? true : false
};
if (!bl.ValidateBrand(brand))
{
bool result = bl.SaveBrand(brand);
return(result);
}
return(false);
}
public BrandModel SaveBrand(BrandModel _objdata)
{
tbl_Brands _objBrand = new tbl_Brands();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
_objBrand.v_name = _objdata.strBrandName;
dataContext.tbl_Brands.Add(_objBrand);
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
_objdata.StatusMessaage = "Brand save sucessfully.";
return(_objdata);
}
}
catch (Exception)
{
throw;
}
}
public ActionResult Create(tbl_Brands obj, HttpPostedFileBase image)
{
try
{
string imgPath = string.Empty;
if (image != null)
{
string filename = Path.GetFileName(image.FileName);
imgPath = Path.Combine(Server.MapPath("~/Images"), Path.GetFileName(image.FileName));
image.SaveAs(imgPath);
imgPath = filename;
//obj.Brandimage = filename;
}
obj.Brandimage = imgPath;
ViewBag.Filestatus = "YES";
db.Sp_Brands_insert(obj.CategoriesID, obj.BrandName, obj.Brandimage);
return(RedirectToAction("List"));
}
// TODO: Add insert logic her
catch
{
return(View());
}
}
