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