private async Task Create(LocalSubSubsidiaries coaLocal)
{
var response = _client.PostAsJsonAsync("api/coa",
new CoaControlPostRequestBody
{
desc = coaLocal.Name,
name = coaLocal.Name,
parent = coaLocal.SubsidiaryRefNo
}).Result;
response.EnsureSuccessStatusCode();
var contents = await response.Content.ReadAsAsync <CoaControlPostResponse>();
coaLocal.RefNo = contents._id;
using (var context = new TMSEntities())
{
var SubSubsidiaries = context.COASubSubsidiaries.FirstOrDefault(w =>
w.ControlCode == coaLocal.ControlCode && w.SubSubsidiaryCode == coaLocal.SubSubsidiaryCode &&
w.GeneralCode == coaLocal.GeneralCode &&
w.SubsidiaryCode == coaLocal.SubsidiaryCode);
if (SubSubsidiaries != null)
{
SubSubsidiaries.RefNo = contents._id;
SubSubsidiaries.UpdatedOn = DateTime.Now;
}
context.SaveChanges();
}
}
private static List <LocalGeneral> GetCoaGeneral(TMSEntities context)
{
return((from control in context.COAControls
join coaGeneral in context.COAGenerals on control.ControlCode equals coaGeneral.ControlCode
select new LocalGeneral
{
GeneralCode = coaGeneral.GeneralCode,
RefNo = coaGeneral.RefNo,
Name = coaGeneral.GeneralDescription,
ControlRefNo = control.RefNo,
ControlCode = control.ControlCode
}
).ToList());
}
static void Main(string[] args)
{
entities = new TMSEntities();
//var menus = (from m in entities.Menus
// join r in entities.RoleMenus on m.MenuId equals r.MenuId
// where r.RoleId == 1 && r.Enabled == true && m.ParentMenuId == null
// select m).Include(i => i.Children).ToList();
entities.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
var result = entities.Menus.Join(entities.RoleMenus, m => m.MenuId, r => r.MenuId, (menu, role) => new { menuList = menu }).SelectMany(i => i.menuList.MenuItems).Where(i => i.ParentMenuId == null).Include(j => j.Children).ToList();
var pagedResult = GetMany(1, 10);
pagedResult = GetMany(2, 10);
pagedResult = GetMany(3, 10);
pagedResult = GetMany(m => m.MenuItemId > 20,1, 10);
pagedResult = GetMany(m => m.MenuItemId > 30, 1, 10);
pagedResult = GetMany(m => m.MenuItemId > 10, 1, 10);
System.Console.ReadLine();
}
private static List <LocalSubsidiaries> GetCoaSubsidiaries(TMSEntities context)
{
return((from coaGeneral in context.COAGenerals
join coaSubsidiaries in context.COASubsidiaries on
new { coaGeneral.ControlCode, coaGeneral.GeneralCode }
equals new
{
coaSubsidiaries.ControlCode,
coaSubsidiaries.GeneralCode
}
select new LocalSubsidiaries
{
SubsidiaryCode = coaSubsidiaries.SubsidiaryCode,
RefNo = coaSubsidiaries.RefNo,
GeneralCode = coaSubsidiaries.GeneralCode,
Name = coaSubsidiaries.SubsidiaryDescription,
GeneralRefNo = coaGeneral.RefNo,
ControlCode = coaGeneral.ControlCode
}
).ToList());
}
static void Main(string[] args)
{
entities = new TMSEntities();
//var menus = (from m in entities.Menus
// join r in entities.RoleMenus on m.MenuId equals r.MenuId
// where r.RoleId == 1 && r.Enabled == true && m.ParentMenuId == null
// select m).Include(i => i.Children).ToList();
entities.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
var result = entities.Menus.Join(entities.RoleMenus, m => m.MenuId, r => r.MenuId, (menu, role) => new { menuList = menu }).SelectMany(i => i.menuList.MenuItems).Where(i => i.ParentMenuId == null).Include(j => j.Children).ToList();
var pagedResult = GetMany(1, 10);
pagedResult = GetMany(2, 10);
pagedResult = GetMany(3, 10);
pagedResult = GetMany(m => m.MenuItemId > 20, 1, 10);
pagedResult = GetMany(m => m.MenuItemId > 30, 1, 10);
pagedResult = GetMany(m => m.MenuItemId > 10, 1, 10);
System.Console.ReadLine();
}
public TMSEntities Init()
{
return dbContext ?? (dbContext = new TMSEntities());
}
public ActionResult Login(LoginViewModel model, string returnUrl)
{
if (ModelState.IsValid)
{
try
{
User user = _userService.ValidateUser(model.Username, model.Password);
if (user == null)
{
ModelState.AddModelError("", "Username is not available");
return View(model);
}
int userRoleId = 1;
string redirectToController = "Home";
if (user is Admin)
{
userRoleId = 1;
redirectToController = "Admin";
}
else if (user is Distributor)
{
userRoleId = 2;
redirectToController = "Distributor";
}
else if (user is Dealer)
{
userRoleId = 3;
redirectToController = "Dealer";
}
else if (user is Customer)
{
userRoleId = 4;
redirectToController = "Customer";
}
CustomPrincipalSerializeModel serializeModel = new CustomPrincipalSerializeModel()
{
UserId = user.UserId,
Username = user.Username,
FirstName = user.FirstName,
LastName = user.LastName,
Role = user.GetType().Name,
UserType = user.GetType()
};
string userData = JsonConvert.SerializeObject(serializeModel);
FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket(1, user.Username, DateTime.Now, DateTime.Now.AddMinutes(30), false, userData);
string encTicket = FormsAuthentication.Encrypt(authTicket);
HttpCookie faCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encTicket)
{
Expires = authTicket.Expiration,
Path = FormsAuthentication.FormsCookiePath
};
Response.Cookies.Add(faCookie);
TMSEntities entities = new TMSEntities();
var menusList =
entities.Menus.Join(entities.RoleMenus.Where(rm => rm.RoleId == userRoleId), m => m.MenuId,
r => r.MenuId, (menu, role) => new { menuList = menu })
.SelectMany(i => i.menuList.MenuItems)
.Where(i => i.ParentMenuId == null)
.Include(j => j.Children)
.ToList();
Session["Menus"] = menusList;
Session["UserData"] = user;
if (!string.IsNullOrWhiteSpace(returnUrl))
{
return Redirect(returnUrl);
}
return RedirectToAction("Index", redirectToController);
}
catch (Exception ex)
{
Logger.ErrorFormat("Controller : {0} - Action : {1}, Message : {2}", this.ControllerContext.RouteData.Values["controller"].ToString(), this.ControllerContext.RouteData.Values["action"].ToString(), ex.Message);
}
}
return View(model);
}
public ActionResult Login(LoginViewModel model, string returnUrl)
{
if (ModelState.IsValid)
{
try
{
User user = _userService.ValidateUser(model.Username, model.Password);
if (user == null)
{
ModelState.AddModelError("", "Username is not available");
return(View(model));
}
int userRoleId = 1;
string redirectToController = "Home";
if (user is Admin)
{
userRoleId = 1;
redirectToController = "Admin";
}
else if (user is Distributor)
{
userRoleId = 2;
redirectToController = "Distributor";
}
else if (user is Dealer)
{
userRoleId = 3;
redirectToController = "Dealer";
}
else if (user is Customer)
{
userRoleId = 4;
redirectToController = "Customer";
}
CustomPrincipalSerializeModel serializeModel = new CustomPrincipalSerializeModel()
{
UserId = user.UserId,
Username = user.Username,
FirstName = user.FirstName,
LastName = user.LastName,
Role = user.GetType().Name,
UserType = user.GetType()
};
string userData = JsonConvert.SerializeObject(serializeModel);
FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket(1, user.Username, DateTime.Now, DateTime.Now.AddMinutes(30), false, userData);
string encTicket = FormsAuthentication.Encrypt(authTicket);
HttpCookie faCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encTicket)
{
Expires = authTicket.Expiration,
Path = FormsAuthentication.FormsCookiePath
};
Response.Cookies.Add(faCookie);
TMSEntities entities = new TMSEntities();
var menusList =
entities.Menus.Join(entities.RoleMenus.Where(rm => rm.RoleId == userRoleId), m => m.MenuId,
r => r.MenuId, (menu, role) => new { menuList = menu })
.SelectMany(i => i.menuList.MenuItems)
.Where(i => i.ParentMenuId == null)
.Include(j => j.Children)
.ToList();
Session["Menus"] = menusList;
Session["UserData"] = user;
if (!string.IsNullOrWhiteSpace(returnUrl))
{
return(Redirect(returnUrl));
}
return(RedirectToAction("Index", redirectToController));
}
catch (Exception ex)
{
Logger.ErrorFormat("Controller : {0} - Action : {1}, Message : {2}", this.ControllerContext.RouteData.Values["controller"].ToString(), this.ControllerContext.RouteData.Values["action"].ToString(), ex.Message);
}
}
return(View(model));
}
public TMSEntities Init()
{
return(dbContext ?? (dbContext = new TMSEntities()));
}
