public ActionResult ViewAccounts()
{
int AccountCode = -1;
dynamic values = new ExpandoObject();
ViewBag.PageCaption = "View/Edit Account Details";
Accounts objAccounts = new Accounts();
int? CSNID = Convert.ToInt32(Session["CSNID"]);
DataSet dsAccountsddl = objAccounts.getAccounsDDL(AccountCode, Convert.ToInt32(Session["CSNID"].ToString()));
dsAccountsddl.Tables[0].TableName = "AccountList";
ViewBag.AccountList = dsAccountsddl.Tables["AccountList"];
dsAccountsddl.Tables[1].TableName = "AccountType";
ViewBag.AccountType = dsAccountsddl.Tables["AccountType"];
dsAccountsddl.Tables[2].TableName = "States";
ViewBag.States = dsAccountsddl.Tables["States"];
//dsAccountsddl.Tables[3].TableName = "csnlist";
// ViewBag.csnlist = dsAccountsddl.Tables["csnlist"];
dsAccountsddl.Tables[4].TableName = "AcctStatus";
ViewBag.AcctStatus = dsAccountsddl.Tables["AcctStatus"];
dsAccountsddl.Tables[5].TableName = "AccountsDetails";
ViewBag.AccountsDetails = dsAccountsddl.Tables["AccountsDetails"];
dsAccountsddl.Tables[6].TableName = "AcctType";
ViewBag.AcctType = dsAccountsddl.Tables["AcctType"];
ViewBag.PageCaption = "View Account Details";
IList<TblAccountList> objAcccount;
dynamic vCsnList;
using (var db = new CSN.DAL.CSNDBEntities())
{
if (Session["RoleID"].ToString() == "1" || Session["RoleId"].ToString() == "28")
{
objAcccount = db.TblAccountLists//.Include("TblCSNLists")
.OrderBy(e => e.Company)
.ToList();
vCsnList = (from x1 in db.TblCSNLists.OrderBy(e => e.FullName)
select new
{
Text = x1.FullName,
Value = x1.CSNID
}).ToList();
}
else
{
objAcccount = db.TblAccountLists//.Include("TblCSNLists")
.Where(e => e.CSNDirID == CSNID)
.OrderBy(e => e.Company)
.ToList();
vCsnList = (from x1 in db.TblCSNLists.Where(e => e.CSNID == CSNID).OrderBy(e => e.FullName)
select new
{
Text = x1.FullName,
Value = x1.CSNID
}).ToList();
}
}
ViewBag.AccountList1 = objAcccount;
ViewBag.csnlist = vCsnList;
return View("~/Views/Accounts/ViewAccounts.cshtml");
}
public ActionResult AccountInfo(int AccountCode)
{
dynamic values = new ExpandoObject();
ViewBag.PageCaption = "View/Edit Account Details";
Accounts objAccounts = new Accounts();
DataSet dsAccountsddl = objAccounts.getAccounsDDL(AccountCode, Convert.ToInt32(Session["CSNID"]));
dsAccountsddl.Tables[0].TableName = "AccountList";
ViewBag.AccountList = dsAccountsddl.Tables["AccountList"];
dsAccountsddl.Tables[1].TableName = "AccountType";
ViewBag.AccountType = dsAccountsddl.Tables["AccountType"];
dsAccountsddl.Tables[2].TableName = "States";
ViewBag.States = dsAccountsddl.Tables["States"];
dsAccountsddl.Tables[3].TableName = "csnlist";
ViewBag.csnlist = dsAccountsddl.Tables["csnlist"];
dsAccountsddl.Tables[4].TableName = "AcctStatus";
ViewBag.AcctStatus = dsAccountsddl.Tables["AcctStatus"];
dsAccountsddl.Tables[5].TableName = "AccountsDetails";
ViewBag.AccountsDetails = dsAccountsddl.Tables["AccountsDetails"];
dsAccountsddl.Tables[6].TableName = "AcctType";
ViewBag.AcctType = dsAccountsddl.Tables["AcctType"];
// ContactList
dynamic values1;
using (var db = new CSN.DAL.CSNDBEntities())
{
values1 = db.TblContactMasters.Include("TblAccountList")
.Where(e => e.AccountCode == AccountCode)
.OrderBy(e => e.FirstName)
.ToList();
}
ViewBag.ContactList = values1;
ViewBag.AccountCode = AccountCode;
return PartialView("~/Views/Shared/Partial/Accounts/AccountInfo.cshtml");
}
public ActionResult SearchBuyers()
{
dynamic values1;
dynamic values = new ExpandoObject();
ViewBag.PageCaption = "View/Edit Buyers List";
Accounts objAccounts = new Accounts();
DataSet dsAccountsddl = objAccounts.getAccounsDDL(-1, Convert.ToInt32(Session["CSNID"]));
dsAccountsddl.Tables[0].TableName = "AccountList";
ViewBag.AccountList = dsAccountsddl.Tables["AccountList"];
dsAccountsddl.Tables[1].TableName = "AccountType";
ViewBag.AccountType = dsAccountsddl.Tables["AccountType"];
dsAccountsddl.Tables[2].TableName = "States";
ViewBag.States = dsAccountsddl.Tables["States"];
dsAccountsddl.Tables[3].TableName = "csnlist";
ViewBag.csnlist = dsAccountsddl.Tables["csnlist"];
dsAccountsddl.Tables[4].TableName = "AcctStatus";
ViewBag.AcctStatus = dsAccountsddl.Tables["AcctStatus"];
dsAccountsddl.Tables[5].TableName = "AccountsDetails";
ViewBag.AccountsDetails = dsAccountsddl.Tables["AccountsDetails"];
dsAccountsddl.Tables[6].TableName = "AcctType";
ViewBag.AcctType = dsAccountsddl.Tables["AcctType"];
using (var db = new CSN.DAL.CSNDBEntities())
{
values1 = db.TblContactMasters.Include("TblAccountList")
//.OrderBy(e => e.TblAccountList.Company)
.ToList();
}
ViewBag.ContactList = values1;
return View("~/Views/Contacts/ViewContacts.cshtml");
}