public ActionResult Paging(int id = 0)
{
int pageNumber;
if (id >= 0)
{
pageNumber = id;
}
else
{
pageNumber = 0;
}
int pageSize = 5;
int recordsToSkip = pageSize * pageNumber;
using (var crmService = new CrmServiceClient(cnString))
{
var ctx = new OrgServiceContext(crmService);
var accounts = ctx.AccountSet.OrderBy(acc => acc.Name).Skip(recordsToSkip).Take(pageSize).ToList();
ViewBag.nextPageNumber = pageNumber + 1;
ViewBag.previousPageNumber = pageNumber - 1;
ViewBag.lastPage = GetAccountsCount() / pageSize;
return(View(accounts));
}
}
public void TestLinqUpdate()
{
var cnString = ConfigurationManager.ConnectionStrings["CrmOnline"].ConnectionString;
using (var crmSvc = new CrmServiceClient(cnString))
{
var ctx = new OrgServiceContext(crmSvc);
var acc = (from a in ctx.AccountSet where a.Name == "Alpine Ski House" select a).ToList();
var acc2 = (from a in ctx.AccountSet
where a.Name.StartsWith("Alpine")
select new { Name = a.Name, Address1_City = a.Address1_City }).ToList();
var acc3 = (from a in ctx.AccountSet
where a.Name.StartsWith("Alpine")
select new Account {
Name = a.Name, Address1_City = a.Address1_City
}).ToList();
var account = new Account();
account.Id = acc.First().Id;
account.Address1_City = "Manchester";
ctx.Attach(account);
var response = ctx.SaveChanges();
account.Address1_City = "Leeds";
response = ctx.SaveChanges();
Assert.IsNotNull(response);
}
}
// GET: Account/Delete/5
public ActionResult Delete(Guid id)
{
using (var crmSvc = new CrmServiceClient(cnString))
{
var ctx = new OrgServiceContext(crmSvc);
var account = ctx.AccountSet.Where(acc => acc.Id == id).Select(acc => acc);
return(View(account.FirstOrDefault()));
}
}
// GET: Account
public ActionResult Index()
{
using (var crmSvc = new CrmServiceClient(cnString))
{
var ctx = new OrgServiceContext(crmSvc);
var accounts = ctx.AccountSet.OrderBy(acc => acc.Name).Take(10).ToList();
return(View(accounts));
}
}
// GET: Account/Create
public ActionResult Create(Account newAccount)
{
using (var svc = new CrmServiceClient(cnString))
{
var ctx = new OrgServiceContext(svc);
ctx.AddObject(newAccount);
ctx.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Edit(Guid id, Account modifiedAccount)
{
using (var crmSvc = new CrmServiceClient(cnString))
{
var ctx = new OrgServiceContext(crmSvc);
ctx.Attach(modifiedAccount);
ctx.UpdateObject(modifiedAccount);
ctx.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Delete(Account accountToDelete)
{
using (var crmSvc = new CrmServiceClient(cnString))
{
var ctx = new OrgServiceContext(crmSvc);
ctx.Attach(accountToDelete);
ctx.DeleteObject(accountToDelete);
ctx.SaveChanges();
return(RedirectToAction("Index"));
}
}
