public static int GetUserIdByName(string userName) { using (PointOfSaleEntities _context = new PointOfSaleEntities()) { return(_context.Database.SqlQuery <int>("select UserId from UserProfile where UserName=" + userName).FirstOrDefault()); } }
//public ReturnMessageModel CreateIssue(ResourceIssueModel riModel) //{ // try // { // using (PointOfSaleEntities _context = new PointOfSaleEntities()) // { // var rtRow = _context.ResourceIssues.Where(x => x.IssueId == riModel.IssueId).FirstOrDefault(); // if (rtRow == null) // { // rtRow = new ResourceIssue(); // } // rtRow.ResourceCopyId = riModel.ResourceCopyId; // rtRow.IssueDate = CommonService.GetEnglishDate(riModel.IssueDateNepali); // rtRow.ReturnBackDate = CommonService.GetEnglishDate(riModel.ReturnDateNepali); // //rtRow.ReturnedDate = CommonService.GetEnglishDate(riModel.GenerationDateNepali); // rtRow.Remarks = riModel.Remarks; // rtRow.subscriber = riModel.SubscriberId; // if (riModel.IssueId == 0) // { // _context.ResourceIssues.Add(rtRow); // _context.SaveChanges(); // } // else // { // _context.ResourceIssues.Attach(rtRow); // _context.Entry(rtRow).State = EntityState.Modified; // _context.SaveChanges(); // } // rModel.Msg = "Issue Saved Successfully"; // rModel.Success = true; // return rModel; // } // } // catch (Exception ex) // { // rModel.Msg = "Issue Saved Failed"; // rModel.Success = false; // return rModel; // } //} public List <ResourceIssueModel> GetResourceIssueList() { using (PointOfSaleEntities context = new PointOfSaleEntities()) { var result = context.ResourceIssues.Select(x => new ResourceIssueModel //where use in after resourceissue { IssueId = x.IssueId, ResourceCopyId = x.ResourceCopyId, IssueDate = x.IssueDate, ReturnBackDate = x.ReturnBackDate, ReturnedDate = x.ReturnedDate, Remarks = x.Remarks, IsActive = x.ResourceCopy.ResourceSetup.IsActive, IsAvailable = x.ResourceCopy.IsAvailable, SubscriberId = x.subscriber, //ResourceGenerationDate=x.ResourceGeneration.GenerationDate FirstName = x.ResourceSubscriber.FirstName, ResourceCopyNumber = x.ResourceCopy.ResourceCopyNumber, //ResourceTypeName=x.ResourceType.ResourceTypeName, //Author=x.ResourceAuthor.Author, //Publisher=x.ResourcePublication.Publisher, //GradeNameEng=x.Grade1.GradeNameEng, //SubjectName=x.Subject1.SubjectName }).ToList(); return(result); } }
public static List <RoleModel> GetRoleList() { using (PointOfSaleEntities _context = new PointOfSaleEntities()) { List <RoleModel> rList = _context.Database.SqlQuery <RoleModel>("Select RoleId,RoleName from webpages_Roles").ToList(); return(rList); } }
public static string GetCurrentNepaliDate(DateTime englishDate) { using (PointOfSaleEntities _context = new PointOfSaleEntities()) { string NepaliDate = _context.Database.SqlQuery <string>("exec EnglishDateToNepali '" + englishDate + "'").FirstOrDefault(); return(NepaliDate); } }
public static DateTime GetEnglishDate(string nepaliDate) { using (PointOfSaleEntities _context = new PointOfSaleEntities()) { var englishDate = _context.Database.SqlQuery <DateTime>("exec NepaliDateToEnglish '" + nepaliDate + "'").FirstOrDefault(); return(englishDate); } }
public static List <SelectModel> GetUsers(string userRole) { using (PointOfSaleEntities _context = new PointOfSaleEntities()) { return(_context.Database.SqlQuery <SelectModel>("SpGetUsers @userRole", new SqlParameter("userRole", userRole) ).ToList()); } }
public ActionResult CreateEditUser(int?UserId) { using (PointOfSaleEntities _context = new PointOfSaleEntities()) { UserProfile profile = new UserProfile(); if (UserId != null) { profile = _context.Database.SqlQuery <UserProfile>("SpGetUserList").Where(x => x.UserId == UserId).FirstOrDefault(); } return(PartialView("_CreateUser", profile)); } }
public static List <RoleControllerActionModel> AssignRoleAuthorization(string Role) { using (PointOfSaleEntities _context = new PointOfSaleEntities()) { List <RoleControllerActionModel> AuthoriseActions = _context.Database.SqlQuery <RoleControllerActionModel>("Exec SJ_SpGetRoleAuthorization '" + Role + "'").ToList(); if (AuthoriseActions == null) { AuthoriseActions = new List <RoleControllerActionModel>(); } return(AuthoriseActions); } }
public static ConfigChoiceModel GetConfigChoiceModel(int choiceId) { using (PointOfSaleEntities _context = new PointOfSaleEntities()) { ConfigChoiceModel model = new ConfigChoiceModel(); model = _context.ConfigChoices.Where(x => x.ChoiceId == choiceId).Select(x => new ConfigChoiceModel { ChoiceId = x.ChoiceId, Choice = x.Choice }).FirstOrDefault(); return(model); } }
public List <ResourceIssueModel> GetSearchedResourceCopy(ResourceIssueModel db) { using (PointOfSaleEntities context = new PointOfSaleEntities()) { return(context.Database.SqlQuery <ResourceIssueModel>("SpGetResourceCopy @resourceCopyId,@authorId,@publicationId,@gradeId,@subjectId", new SqlParameter("resourceCopyId", db.ResourceId), new SqlParameter("authorId", db.AuthorId ?? SqlInt32.Null), new SqlParameter("publicationId", db.PublicationId ?? SqlInt32.Null), new SqlParameter("gradeId", db.GradeId ?? SqlInt32.Null), new SqlParameter("subjectId", db.SubjectId ?? SqlInt32.Null) ).ToList()); } }
public SetupController() { _iSetupService = new SetupService(); rModel = new ReturnMessageModel(); _iResourceService = new ResourceService(); context = new PointOfSaleEntities(); _iCountryService = new CountryService(); context = new PointOfSaleEntities(); _iResourceAuthorService = new ResourceAuthorService(); context = new PointOfSaleEntities(); _iResourcePublicationService = new ResourcePublicationService(); context = new PointOfSaleEntities(); }
public static List <SelectModel> GetConfigChoices(string category) { using (PointOfSaleEntities _context = new PointOfSaleEntities()) { List <SelectModel> rList = (from c in _context.ConfigChoices where c.ConfigChoiceCategory.Category == category && c.IsActive == true select new SelectModel() { SelectId = c.ChoiceId, SelectText = c.Choice }).OrderBy(p => p.SelectText).ToList(); return(rList); } }
public static ConfigChoiceCategoryModel GetConfigChoiceCategoryById(int categoryId) { using (PointOfSaleEntities _context = new PointOfSaleEntities()) { var cccModel = _context.ConfigChoiceCategories .Where(x => x.CategoryId == categoryId) .Select(x => new ConfigChoiceCategoryModel { CategoryId = x.CategoryId, Category = x.Category, CategoryDescription = x.CategoryDescription }).FirstOrDefault(); return(cccModel); } }
public ReturnMessageModel CreateEditResourceAuthor(ResourceAuthorModel raModel) { try { using (PointOfSaleEntities _context = new PointOfSaleEntities()) { var rtRow = _context.ResourceAuthors.Where(x => x.AuthorId == raModel.AuthorId).FirstOrDefault(); if (rtRow == null) { rtRow = new ResourceAuthor(); } rtRow.Author = raModel.Author; rtRow.Nationality = raModel.Nationality; rtRow.Genere = raModel.Genere; rtRow.IsActive = raModel.IsActive; if (raModel.AuthorId == 0) { rtRow.CreatedBy = WebSecurity.CurrentUserId; rtRow.CreatedDate = System.DateTime.Now; _context.ResourceAuthors.Add(rtRow); _context.SaveChanges(); } else { rtRow.ModifiedBy = WebSecurity.CurrentUserId; rtRow.ModifiedDate = System.DateTime.Now; _context.ResourceAuthors.Attach(rtRow); _context.Entry(rtRow).State = EntityState.Modified; _context.SaveChanges(); } rModel.Msg = "Resource Type Saved Successfully"; rModel.Success = true; return(rModel); } } catch (Exception ex) { rModel.Msg = "Resource Type Saved Failed"; rModel.Success = false; return(rModel); } }
public List <CountryModel> GetCountryList() { using (PointOfSaleEntities context = new PointOfSaleEntities()) { var result = context.Countries.Select(x => new CountryModel { CountryId = x.CountryId, CountryName = x.CountryName, IsActive = x.IsActive, CreatedDate = x.CreatedDate, CreatedBy = x.CreatedBy, ModifiedDate = x.ModifiedDate, ModifiedBy = x.ModifiedBy }).ToList(); return(result); } }
public List <ResourceGenerationModel> GetResourceGenerationList() { using (PointOfSaleEntities context = new PointOfSaleEntities()) { var result = context.ResourceGenerations.Select(x => new ResourceGenerationModel { GenerationId = x.GenerationId, ResourceId = x.ResourceId, GenerationDate = x.GenerationDate, GenerationCopyCount = x.GenerationCopyCount, Remarks = x.Remarks, ResourceName = x.ResourceSetup.ResourceName }).ToList(); return(result); } }
public List <ResourceTypeModel> GetResourceTypeList() { using (PointOfSaleEntities context = new PointOfSaleEntities()) { var result = context.ResourceTypes.Select(x => new ResourceTypeModel { ResourceTypeId = x.ResourceTypeId, ResourceTypeName = x.ResourceTypeName, ResourceTypeCode = x.ResourceTypeCode, IsActive = x.IsActive, CreatedDate = x.CreatedDate, CreatedBy = x.CreatedBy, ModifiedDate = x.ModifiedDate, ModifiedBy = x.ModifiedBy }).ToList(); return(result); } }
public ReturnMessageModel CreateEditCountry(CountryModel cModel) { try { using (PointOfSaleEntities _context = new PointOfSaleEntities()) { var rtRow = _context.Countries.Where(x => x.CountryId == cModel.CountryId).FirstOrDefault(); if (rtRow == null) { rtRow = new Country(); } rtRow.CountryName = cModel.CountryName; rtRow.IsActive = cModel.IsActive; if (cModel.CountryId == 0) { rtRow.CreatedBy = WebSecurity.CurrentUserId; rtRow.CreatedDate = System.DateTime.Now; _context.Countries.Add(rtRow); _context.SaveChanges(); } else { rtRow.ModifiedBy = WebSecurity.CurrentUserId; rtRow.ModifiedDate = System.DateTime.Now; _context.Countries.Attach(rtRow); _context.Entry(rtRow).State = EntityState.Modified; _context.SaveChanges(); } rModel.Msg = "Country Saved Successfully"; rModel.Success = true; return(rModel); } } catch (Exception ex) { rModel.Msg = "Country Saved Failed"; rModel.Success = false; return(rModel); } }
public JsonResult CheckLogin(string username, string password) { PointOfSaleEntities db = new PointOfSaleEntities(); string md5StringPassword = AppHelper.GetMd5Hash(password); var dataItem = db.Users.Where(x => x.Username == username && x.Password == md5StringPassword).SingleOrDefault(); bool isLogged = true; if (dataItem != null) { //FormsAuthentication.SetAuthCookie(dataItem.Username, false); Session["Username"] = dataItem.Username; isLogged = true; } else { isLogged = false; } return(Json(isLogged, JsonRequestBehavior.AllowGet)); }
public ReturnMessageModel CreateResourceCopies(ResourceGenerationModel rgModel) { try { using (PointOfSaleEntities context = new PointOfSaleEntities()) { var gRow = new ResourceGeneration(); gRow.ResourceId = rgModel.ResourceId; gRow.Remarks = rgModel.Remarks; gRow.GenerationCopyCount = rgModel.GenerationCopyCount; gRow.GenerationDate = CommonService.GetEnglishDate(rgModel.GenerationDateNepali); context.ResourceGenerations.Add(gRow); context.SaveChanges(); //for Resoruce copies for (int i = 0; i < rgModel.GenerationCopyCount; i++) { var rRow = new ResourceCopy(); rRow.GenerationId = gRow.GenerationId; rRow.ResourceId = rgModel.ResourceId; rRow.ResourceCopyCount = i + 1; rRow.ResourceCopyNumber = rgModel.ResourceName + "-" + rgModel.ResourceId.ToString() + ":" + gRow.GenerationId.ToString() + ":" + i.ToString(); rRow.Remarks = rgModel.Remarks; rRow.IsAvailable = rgModel.IsAvailable; rRow.PublishedDate = CommonService.GetEnglishDate(rgModel.GenerationDateNepali); rRow.Edition = "new edition"; context.ResourceCopies.Add(rRow); } context.SaveChanges(); rModel.Msg = "SUceess"; rModel.Success = true; return(rModel); } } catch (Exception ex) { rModel.Msg = "fail"; rModel.Success = false; return(rModel); } }
public List <ResourcePublicationModel> GetResourcePublicationList() { using (PointOfSaleEntities context = new PointOfSaleEntities()) { var result = context.ResourcePublications.Select(x => new ResourcePublicationModel { PublicationId = x.PublicationId, Publisher = x.Publisher, PublisherOrigin = x.PublisherOrigin, Genere = x.Genere, IsActive = x.IsActive, CreatedDate = x.CreatedDate, CreatedBy = x.CreatedBy, ModifiedDate = x.ModifiedDate, ModifiedBy = x.ModifiedBy, CountryName = x.Country.CountryName }).ToList(); return(result); } }
public static List <ConfigChoiceModel> GetConfigChoiceListByCategory(string categoryName) { using (PointOfSaleEntities _context = new PointOfSaleEntities()) { var ccModel = (from ccc in _context.ConfigChoiceCategories join cc in _context.ConfigChoices on ccc.CategoryId equals cc.CategoryId where ccc.Category == categoryName select new ConfigChoiceModel { CategoryId = ccc.CategoryId, CategoryName = ccc.Category, Choice = cc.Choice, ChoiceDescription = cc.ChoiceDescription, ChoiceId = cc.ChoiceId, Val = cc.Val }).ToList(); return(ccModel); } }
public List <ResourceAuthorModel> GetResourceAuthorList() { using (PointOfSaleEntities context = new PointOfSaleEntities()) { var result = context.ResourceAuthors.Select(x => new ResourceAuthorModel { AuthorId = x.AuthorId, Author = x.Author, Nationality = x.Nationality, Genere = x.Genere, IsActive = x.IsActive, CreatedDate = x.CreatedDate, CreatedBy = x.CreatedBy, ModifiedDate = x.ModifiedDate, ModifiedBy = x.ModifiedBy, CountryName = x.Country.CountryName }).ToList(); return(result); } }
public List <ResourceCopyModel> GetResourceCopiesList() { using (PointOfSaleEntities context = new PointOfSaleEntities()) { var result = context.ResourceCopies.Select(x => new ResourceCopyModel { ResourceCopyId = x.ResourceCopyId, GenerationId = x.GenerationId, ResourceId = x.ResourceId, ResourceCopyCount = x.ResourceCopyCount, ResourceCopyNumber = x.ResourceCopyNumber, Remarks = x.Remarks, IsAvailable = x.IsAvailable, PublishedDate = x.PublishedDate, Edition = x.Edition, ResourceName = x.ResourceSetup.ResourceName, ResourceGenerationDate = x.ResourceGeneration.GenerationDate, }).ToList(); return(result); } }
public ReturnMessageModel CreateResourceIssue(ResourceIssueModel riModel) { try { using (PointOfSaleEntities _context = new PointOfSaleEntities()) { var rtRow = _context.ResourceIssues.Where(x => x.IssueId == riModel.IssueId).FirstOrDefault(); if (rtRow == null) { rtRow = new ResourceIssue(); } rtRow.ResourceCopyId = riModel.ResourceCopyId; rtRow.IssueDate = CommonService.GetEnglishDate(riModel.IssueDateNepali); rtRow.ReturnBackDate = CommonService.GetEnglishDate(riModel.ReturnDateNepali); rtRow.ReturnedDate = CommonService.GetEnglishDate(riModel.ReturnDateNepali); rtRow.Remarks = riModel.Remarks; rtRow.subscriber = riModel.SubscriberId; _context.ResourceIssues.Add(rtRow); _context.SaveChanges(); rModel.Msg = "Issue Saved Successfully"; rModel.Success = true; return(rModel); } } catch (Exception ex) { rModel.Msg = "Issue Saved Failed"; rModel.Success = false; return(rModel); } }
public ActionResult UserLists(string activeType = "All") { using (PointOfSaleEntities _context = new PointOfSaleEntities()) { UserProfile userProfile = new UserProfile(); int userId = WebSecurity.CurrentUserId; //Guid uniqueId = CommonService.GetCurrentUserUniqueId(userId); string userRole = Roles.GetRolesForUser().FirstOrDefault(); // userProfile.ActiveStatus = activeType; userProfile.UserList = _context.Database.SqlQuery <UserProfile>("SpGetUserList").ToList(); if (activeType == "Active") { userProfile.UserList = userProfile.UserList.Where(x => x.CanLogin == true).ToList(); } else if (activeType == "InActive") { userProfile.UserList = userProfile.UserList.Where(x => x.CanLogin == false).ToList(); } return(View(userProfile)); } }
public ReturnMessageModel CreateResourceGeneration(ResourceGenerationModel rgModel) { try { using (PointOfSaleEntities _context = new PointOfSaleEntities()) { var rtRow = _context.ResourceGenerations.Where(x => x.GenerationId == rgModel.GenerationId).FirstOrDefault(); if (rtRow == null) { rtRow = new ResourceGeneration(); } rtRow.ResourceId = rgModel.ResourceId; //rtRow.GenerationDate = rgModel.GenerationDate; rtRow.GenerationCopyCount = rgModel.GenerationCopyCount; rtRow.Remarks = rgModel.Remarks; if (rgModel.GenerationId == 0) { rtRow.GenerationDate = System.DateTime.Now; _context.ResourceGenerations.Add(rtRow); _context.SaveChanges(); } else { _context.ResourceGenerations.Attach(rtRow); _context.Entry(rtRow).State = EntityState.Modified; _context.SaveChanges(); } var gRow = _context.ResourceCopies.Where(x => x.ResourceCopyId == rgModel.ResourceCopyId).FirstOrDefault(); if (gRow == null) { gRow = new ResourceCopy(); } for (int i = 1; i < rgModel.GenerationCopyCount; i++) { gRow.ResourceCopyId = rgModel.ResourceCopyId; gRow.ResourceId = rgModel.ResourceId; gRow.GenerationId = rgModel.GenerationId; gRow.ResourceCopyCount = i; //gRow.ResourceCopyNumber = ResourceId.ToString() + rgModel.GenerationId + rgModel.ResourceCopyId; } //rtRow.GenerationId rModel.Msg = "Resource Type Saved Successfully"; rModel.Success = true; return(rModel); } } catch (Exception ex) { rModel.Msg = "Resource Type Saved Failed"; rModel.Success = false; return(rModel); } }
public SetupService() { rModel = new ReturnMessageModel(); _context = new PointOfSaleEntities(); }