protected void fubtn_Click(object sender, EventArgs e) { string filename = @"D:\cou.xlsx"; FileStream str = File.Open(filename, FileMode.Open, FileAccess.Read); //str = File.Open("E:\\cou.xlsx", FileMode.Open, FileAccess.Read); IExcelDataReader ir = ExcelReaderFactory.CreateOpenXmlReader(str); System.Data.DataSet ds = ir.AsDataSet(); Countrycontroller countrycon = new Countrycontroller(); Countryinfo countryinfo = new Countryinfo(); List <Countryinfo> countryli = new List <Countryinfo>(); foreach (DataTable obj in ds.Tables) { foreach (DataRow robj in obj.Rows) { countryinfo = new Countryinfo(); countryinfo.Country_Name = Convert.ToString(robj[0]); countryinfo.Country_Code = Convert.ToString(robj[1]); countryinfo.Country_Description = Convert.ToString(robj[0]); countrycon.InsertCountry(countryinfo); } } ir.Close(); str.Close(); SelectAllCountry(); }
public List <Countryinfo> selectallcountryinfo() { try { List <Countryinfo> listcountryinfo = new List <Countryinfo>(); { using (RMSDataContext db = new RMSDataContext()) { Countryinfo countryinfo; var a = (from o in db.Countries select o).ToList(); foreach (var obj in a) { countryinfo = new Countryinfo(); countryinfo.CountryID = obj.CountryID; countryinfo.Country_Name = obj.Country_Name; countryinfo.Country_Code = obj.Country_Code; countryinfo.Country_Description = obj.Country_Description; countryinfo.RegionID = obj.RegionID; listcountryinfo.Add(countryinfo); } return(listcountryinfo); } } } catch (Exception ex) { return(new List <Countryinfo>()); } }
protected void btnSave_Click(object sender, EventArgs e) { Countrycontroller countryCtlr = new Countrycontroller(); Countryinfo countryInfo = new Countryinfo(); countryInfo.Country_Name = txtCountryName.Text; countryInfo.Country_Code = txtCountryCode.Text; countryInfo.Country_Description = txtCountryDescription.Text; countryInfo.RegionID = regionData.SelectedValue; countryCtlr.InsertCountry(countryInfo); SelectAllCountry(); }
public void insertcountry(Countryinfo couninfo) { using (RMSDataContext db = new RMSDataContext()) { Country contrytbl = new Country(); contrytbl.CountryID = couninfo.CountryID; contrytbl.Country_Name = couninfo.Country_Name; contrytbl.Country_Code = couninfo.Country_Code; contrytbl.Country_Description = couninfo.Country_Description; contrytbl.RegionID = couninfo.RegionID; db.Countries.InsertOnSubmit(contrytbl); db.SubmitChanges(); } }
public void DeleteCountryByCountryID(Countryinfo couninfo) { try { using (RMSDataContext db = new RMSDataContext()) { var obj = (from c in db.Countries where c.CountryID == couninfo.CountryID select c).First(); db.Countries.DeleteOnSubmit(obj); db.SubmitChanges(); } } catch (Exception ex) { Country c = new Country(); } }
public void UpdateCountryByCountryID(Countryinfo couninfo) { try { using (RMSDataContext db = new RMSDataContext()) { var obj = (from country in db.Countries where country.CountryID == couninfo.CountryID select country).First(); obj.Country_Name = couninfo.Country_Name; obj.Country_Description = couninfo.Country_Description; obj.Country_Code = couninfo.Country_Code; obj.RegionID = couninfo.RegionID; db.SubmitChanges(); } } catch (Exception ex) { Country coun = new Country(); } }
public void DeleteCountry(Countryinfo countryInfo) { countrydao.DeleteCountryByCountryID(countryInfo); }
public void UpdateCountry(Countryinfo countryInfo) { countrydao.UpdateCountryByCountryID(countryInfo); }
public void InsertCountry(Countryinfo countryInfo) { countrydao.insertcountry(countryInfo); }