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();
}
