// GET: Home
public ActionResult Index()
{
TestBaseEntities entities = new TestBaseEntities();
return(View(from customer in entities.Customers.Take(10)
select customer));
}
public FileResult Export()
{
TestBaseEntities entities = new TestBaseEntities();
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[4] {
new DataColumn("CustomerId"),
new DataColumn("ContactName"),
new DataColumn("City"),
new DataColumn("Country")
});
var customers = from customer in entities.Customers.Take(10)
select customer;
foreach (var customer in customers)
{
dt.Rows.Add(customer.CustomerID, customer.ContactName, customer.City, customer.Country);
}
using (XLWorkbook wb = new XLWorkbook())
{
wb.Worksheets.Add(dt);
using (MemoryStream stream = new MemoryStream())
{
wb.SaveAs(stream);
return(File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Grid.xlsx"));
}
}
}
private List <State> GetState()
{
using (TestBaseEntities dc = new TestBaseEntities())
{
return(dc.States.OrderBy(a => a.StateName).ToList());
}
}
//Here I have written the below function "GetContact" into "Contacts" Controller.
public Contact GetContact(int contactID)
{
Contact contact = null;
using (TestBaseEntities dc = new TestBaseEntities())
{
var v = (from a in dc.Contacts
join b in dc.Countries on a.CountryID equals b.CountryID
join c in dc.States on a.StateID equals c.StateID
where a.ContactID.Equals(contactID)
select new
{
a,
b.CountryName,
c.StateName
}).FirstOrDefault();
if (v != null)
{
contact = v.a;
contact.CountryName = v.CountryName;
contact.StateName = v.StateName;
}
return(contact);
}
}
//edit and create country / state contact
private List <Country> GetCountry()
{
using (TestBaseEntities dc = new TestBaseEntities())
{
return(dc.Countries.OrderBy(a => a.CountryName).ToList());
}
}
//
// GET: /Contacts/
public ActionResult Index()
{
List <Contact> allContacts = null;
using (TestBaseEntities dc = new TestBaseEntities())
{
var v = (from a in dc.Contacts
join b in dc.Countries on a.CountryID equals b.CountryID
join c in dc.States on a.StateID equals c.StateID
select new
{
a,
b.CountryName,
c.StateName
});
if (v != null)
{
allContacts = new List <Contact>();
foreach (var i in v)
{
Contact c = i.a;
c.CountryName = i.CountryName;
c.StateName = i.StateName;
allContacts.Add(c);
}
}
}
return(View(allContacts));
}
//Write function for return state list of selected country in json format, which we will use for cascade dropdown.
public JsonResult GetStateList(int countryID)
{
using (TestBaseEntities dc = new TestBaseEntities())
{
return(new JsonResult {
Data = GetState(), JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public ActionResult DeleteContact(int id)
{
using (TestBaseEntities dc = new TestBaseEntities())
{
var v = dc.Contacts.Where(a => a.ContactID.Equals(id)).FirstOrDefault();
if (v != null)
{
dc.Contacts.Remove(v);
dc.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(HttpNotFound());
}
}
}
public ActionResult Save(Contact c)
{
string message = "";
bool status = false;
//Save
if (ModelState.IsValid)
{
using (TestBaseEntities dc = new TestBaseEntities())
{
if (c.ContactID > 0)
{
//Update
var v = dc.Contacts.Where(a => a.ContactID.Equals(c.ContactID)).FirstOrDefault();
if (v != null)
{
v.ContactPerson = c.ContactPerson;
v.ContactNo = c.ContactNo;
v.CountryID = c.CountryID;
v.StateID = c.StateID;
}
else
{
return(HttpNotFound());
}
}
else
{
//Add new
dc.Contacts.Add(c);
}
dc.SaveChanges();
status = true;
return(RedirectToAction("Index"));
}
}
else
{
message = "Error! Please try again.";
ViewBag.Countries = new SelectList(GetCountry(), "CountryID", "CountryName", c.CountryID);
ViewBag.States = new SelectList(GetState(), "StateID", "StateName", c.StateID);
}
ViewBag.Message = message;
ViewBag.Status = status;
return(View(c));
}
