protected void btnSave_Click(object sender, EventArgs e)
{
brandinfoinfo sinfo = new brandinfoinfo();
BrandController sCon = new BrandController();
string fn = @"D:\BrandLst.xlsx";
FileStream fs = File.Open(fn, FileMode.Open, FileAccess.Read);
IExcelDataReader ir = ExcelReaderFactory.CreateOpenXmlReader(fs);
DataSet ds = ir.AsDataSet();
foreach (DataTable tobj in ds.Tables)
{
foreach (DataRow robj in tobj.Rows)
{
//sinfo.BrandID = Convert.ToString(robj[0]);
sinfo.BrandName = Convert.ToString(robj[0]);
sinfo.Model = Convert.ToString(robj[0]);
sinfo.CategoryID = Convert.ToString(robj[1]);
sCon.InsertBrandByBrandID(sinfo);
}
}
ir.Close();
fs.Close();
}
public List <brandinfoinfo> selectAllBrandInfoCatID(string cat)
{
try
{
using (RMSDataContext db = new RMSDataContext())
{
List <brandinfoinfo> lstbrinfo = new List <brandinfoinfo>();
{
brandinfoinfo binfo;
var b = (from br in db.brands where br.CategoryID == cat select br).ToList();
foreach (var obj in b)
{
binfo = new brandinfoinfo();
binfo.BrandID = obj.BrandID;
binfo.BrandName = obj.BrandName;
binfo.Model = obj.Model;
binfo.CategoryID = obj.CategoryID;
lstbrinfo.Add(binfo);
}
return(lstbrinfo);
}
}
}
catch (Exception ex)
{
return(new List <brandinfoinfo>());
}
}
public void deleteBrand(brandinfoinfo brinfo)
{
using (RMSDataContext db = new RMSDataContext())
{
var obj = (from a in db.brands where a.BrandID == brinfo.BrandID select a).First();
db.brands.DeleteOnSubmit(obj);
db.SubmitChanges();
}
}
public void UpdateBrandByUpdateID(brandinfoinfo brinfo)
{
using (RMSDataContext db = new RMSDataContext())
{
var obj = (from a in db.brands where a.BrandID == brinfo.BrandID select a).First();
obj.BrandID = brinfo.BrandID;
obj.BrandName = brinfo.BrandName;
obj.Model = brinfo.Model;
db.SubmitChanges();
}
}
public void InsertBrand(brandinfoinfo brinfo)
{
try
{
using (RMSDataContext db = new RMSDataContext())
{
brand tbl = new brand();
Guid bid = Guid.NewGuid();
tbl.BrandID = bid.ToString();
tbl.BrandName = brinfo.BrandName;
tbl.Model = brinfo.Model;
tbl.CategoryID = brinfo.CategoryID;
db.brands.InsertOnSubmit(tbl);
db.SubmitChanges();
}
}
catch (Exception ex)
{
brand tbl = new brand();
}
}
public brandinfoinfo selectBrandInfoByBrandID(brandinfoinfo brinfo)
{
try
{
using (RMSDataContext db = new RMSDataContext())
{
brandinfoinfo binfo;
var b = (from a in db.brands where a.BrandID == brinfo.BrandID select a).First();
binfo = new brandinfoinfo();
binfo.BrandID = b.BrandID;
binfo.BrandName = b.BrandName;
binfo.CategoryID = b.CategoryID;
binfo.Model = b.Model;
return(binfo);
}
}
catch (Exception ex)
{
return(new brandinfoinfo());
}
}
public void DeleteBrandByBrandID(brandinfoinfo bfo)
{
brDao.deleteBrand(bfo);
}
public void UpdateBrandByBrandID(brandinfoinfo bfo)
{
brDao.UpdateBrandByUpdateID(bfo);
}
public void InsertBrandByBrandID(brandinfoinfo bfo)
{
brDao.InsertBrand(bfo);
}
public brandinfoinfo SelectBrandByBrandID(brandinfoinfo bfo)
{
brinfo = new brandinfoinfo();
brinfo = brDao.selectBrandInfoByBrandID(bfo);
return(brinfo);
}
