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); }