public ActionResult ReturnIndex(ResourceIssueModel riModel)
{
ResourceIssueModel db = new ResourceIssueModel();
db.GetResourceIssueList = _iResourceIssue.GetResourceIssueList();
return(View(db));
}
public ActionResult ResourceIssueIndex()
{
ResourceIssueModel db = new ResourceIssueModel();
ViewBag.FirstName = new SelectList(_iSetupService.GetResourceSubscriberList(), "SuscriberId", "FirstName");
db.GetResourceIssueList = _iResourceIssue.GetResourceIssueList();
return(View(db));
}
public ActionResult CreateReturn(int issueId)
{
ResourceIssueModel riModel = new ResourceIssueModel();
riModel = _iResourceIssue.GetResourceIssueList().Where(x => x.IssueId == issueId).FirstOrDefault();
riModel.ReturnedDateNepali = CommonService.GetCurrentNepaliDate(DateTime.Now);
return(PartialView("_CreateRetrun", riModel));
}
public ActionResult ResourceIssueIndex(ResourceIssueModel riModel)
{
ViewBag.FirstName = new SelectList(_iSetupService.GetResourceSubscriberList(), "SubscriberId", "FirstName");
if (riModel.SubscriberId > 0)
{
riModel.GetResourceIssueList = _iResourceIssue.GetResourceIssueList().Where(x => x.SubscriberId == riModel.SubscriberId && x.ReturnedDate == null).ToList();
}
return(View(riModel));
}
public ActionResult CreateResourceIssue(int resourceCopyId, int subscriberId)
{
ResourceIssueModel riModel = new ResourceIssueModel();
riModel.ResourceCopyNumber = _iResourceService.GetResourceCopiesList().Where(x => x.ResourceCopyId == resourceCopyId).FirstOrDefault().ResourceCopyNumber;
riModel.ResourceCopyId = resourceCopyId;
riModel.SubscriberId = subscriberId;
riModel.IssueDateNepali = CommonService.GetCurrentNepaliDate(DateTime.Now);
riModel.ReturnDateNepali = CommonService.GetCurrentNepaliDate(DateTime.Now.AddDays(+7));
return(PartialView("_CreateResourceIssue", riModel));
}
public ActionResult CreateReturn(ResourceIssueModel riModel)
{
if (ModelState.IsValid)
{
var result = _iResourceIssue.CreateResourceIssue(riModel);
return(Json(result, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(rModel, JsonRequestBehavior.AllowGet));
}
}
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 ActionResult IssueIndex(ResourceIssueModel db)
{
//ResourceIssueModel db = new ResourceIssueModel();
ViewBag.ResourceList = new SelectList(_iSetupService.GetResourceSetupList(), "ResourceId", "ResourceName");
ViewBag.Author = new SelectList(_iResourceAuthorService.GetResourceAuthorList(), "AuthorId", "Author");
ViewBag.Publisher = new SelectList(_iResourcePublicationService.GetResourcePublicationList(), "PublicationId", "Publisher");
ViewBag.GradeNameEng = new SelectList(_iSetupService.GetGradeList(), "GradeId", "GradeNameEng");
ViewBag.Subject = new SelectList(_iSetupService.GetSubjectList(), "SubjectId", "SubjectName");
if (db.ResourceId > 0)
{
db.GetResourceIssueList = _iResourceIssue.GetSearchedResourceCopy(db);
}
return(View(db));
}
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);
}
}
