public async Task <IHttpActionResult> search(DAL.UserType model) { System.Web.HttpContext.Current.Application.Lock(); //var category = from m in _db.Categories select m; var UserTypes = from ut in _db.UserTypes select new { UserTypeId = ut.UserTypeId, UserTypeName = ut.UserTypeName, status = ut.status }; if (model.UserTypeName != null) { UserTypes = from ut in UserTypes where ut.UserTypeName.Contains(model.UserTypeName) select ut; } if (model.status != 0) { UserTypes = from ut in UserTypes where ut.status == model.status select ut; } UserTypes = from ut in UserTypes orderby ut.UserTypeName select ut; System.Web.HttpContext.Current.Application.UnLock(); return(Json(UserTypes)); }
void UserSetup(BLL.FundMaster fm) { DAL.UserAccount ua = new DAL.UserAccount(); ua.LoginId = fm.UserId; ua.UserName = fm.UserId; ua.Password = fm.Password; DAL.UserType ut = new DAL.UserType(); ut.TypeOfUser = BLL.DataKeyValue.Administrator_Key; ut.FundMasterId = fm.Id; ut.UserAccounts.Add(ua); foreach (var utfd in DB.UserTypeFormDetails) { DAL.UserTypeDetail utd = new DAL.UserTypeDetail(); utd.UserTypeFormDetailId = utfd.Id; utd.IsViewForm = true; utd.AllowInsert = true; utd.AllowUpdate = true; utd.AllowDelete = true; ut.UserTypeDetails.Add(utd); } DB.UserTypes.Add(ut); DB.SaveChanges(); SetDataKeyValue(fm.Id, ut.TypeOfUser, ut.Id); }
private BLL.UserType UserTypeDAL_BLL(DAL.UserType d) { BLL.UserType b = d.toCopy <BLL.UserType>(new BLL.UserType()); if (d != null) { b.UserTypeDetails = new ObservableCollection <BLL.UserTypeDetail>(d.UserTypeDetails.Select(x => UserTypeDetailDAL_BLL(x)).ToList()); b.Company = d.CompanyDetail.toCopy <BLL.CompanyDetail>(new BLL.CompanyDetail()); } return(b); }
private BLL.UserType UserTypeDAL_BLL(DAL.UserType d) { BLL.UserType b = d.toCopy <BLL.UserType>(new BLL.UserType()); if (d != null) { b.UserTypeDetails = new ObservableCollection <BLL.UserTypeDetail>(d.UserTypeDetails.Select(x => UserTypeDetailDAL_BLL(x)).ToList()); b.Fund = d.FundMaster.toCopy <BLL.FundMaster>(new BLL.FundMaster()); } return(b); }
public int userType_Save(BLL.UserType ut) { try { DAL.UserType d = DB.UserTypes.Where(x => x.Id == ut.Id).FirstOrDefault(); if (d == null) { var c = DB.CompanyDetails.Where(x => x.Id == ut.CompanyId).FirstOrDefault(); d = new DAL.UserType(); c.UserTypes.Add(d); ut.toCopy <DAL.UserType>(d); foreach (var utd in ut.UserTypeDetails) { d.UserTypeDetails.Add(utd.toCopy <DAL.UserTypeDetail>(new DAL.UserTypeDetail())); } DB.SaveChanges(); ut.Id = d.Id; ut.Company = c.toCopy <BLL.CompanyDetail>(new BLL.CompanyDetail()); LogDetailStore(ut, LogDetailType.INSERT); } else { ut.toCopy <DAL.UserType>(d); foreach (var utd in ut.UserTypeDetails) { DAL.UserTypeDetail dd = d.UserTypeDetails.Where(x => x.Id == utd.Id).FirstOrDefault(); if (dd == null) { dd = new DAL.UserTypeDetail(); d.UserTypeDetails.Add(dd); } utd.toCopy <DAL.UserTypeDetail>(dd); } DB.SaveChanges(); LogDetailStore(ut, LogDetailType.UPDATE); } Clients.Clients(OtherLoginClientsOnGroup).userType_Save(ut); return(ut.Id); } catch (Exception ex) { } return(0); }