/// <summary> /// method to check, whether Activity already exists in database. /// </summary> /// <param name="activity"></param> /// <returns></returns> public string CheckActivityExists(InkindActivity activity) { string existsCode = ""; existsCode = new InKindData().CheckActivityExists(activity); return(existsCode); }
/// <summary> /// Method to insert the In-kind Activities from View Page. /// </summary> /// <param name="inkindActivity"></param> /// <returns>Json Result</returns> public JsonResult InsertInkindActivity(string inkindActivity) { bool isResut = false; string returnResult = string.Empty; try { JavaScriptSerializer serializer = new JavaScriptSerializer(); InkindActivity activity = new InkindActivity(); activity = serializer.Deserialize <InkindActivity>(inkindActivity); //activity.StaffDetails = new StaffDetails //{ // UserId = new Guid(Session["UserID"].ToString()), // RoleId = new Guid(Session["RoleID"].ToString()), // AgencyId = (Session["AgencyId"] == null) ? (Guid?)null : new Guid(Session["AgencyID"].ToString()) //}; returnResult = CheckActivityExists(activity); if (returnResult == "0") { isResut = new InKindData().InsertInkindActivity(activity); returnResult = (isResut) ? "1" : "4"; } } catch (Exception ex) { clsError.WriteException(ex); } return(Json(returnResult, JsonRequestBehavior.AllowGet)); }
public JsonResult InsertInkindActivity(string inkindActivity) { bool isResut = false; string returnResult = string.Empty; try { JavaScriptSerializer serializer = new JavaScriptSerializer(); InkindActivity activity = new InkindActivity(); activity = serializer.Deserialize <InkindActivity>(inkindActivity); returnResult = CheckActivityExists(activity); if (returnResult == "0") { isResut = new InKindData().InsertInkindActivity(activity); returnResult = (isResut) ? "1" : "4"; } } catch (Exception ex) { clsError.WriteException(ex); } return(Json(returnResult, JsonRequestBehavior.AllowGet)); }
public JsonResult GetParentCompanyDonorsBySearch(int requestedPage, int pageSize, string searchName = "") { Inkind inkind; inkind = new InKindData().GetInkindParentCompanyDonors(staff, searchName, requestedPage, pageSize); return(Json(inkind, JsonRequestBehavior.AllowGet)); }
public JsonResult GetInkindPeriodYakkrMappings(string yakkrId) { List <InkindPeriods> inkindPeriodList; inkindPeriodList = new InKindData().GetInkindPeriodYakkrMappingData(staff, yakkrId); return(Json(inkindPeriodList, JsonRequestBehavior.AllowGet)); }
public JsonResult ActivateNewInkindPeriod(string yakkrId) { bool isResult = false; isResult = new InKindData().ActivateNewInkindPeriodData(staff, yakkrId); return(Json(isResult, JsonRequestBehavior.AllowGet)); }
public ActionResult ParentParticipation() { ParentParticipation parentParticipation; parentParticipation = new InKindData().GetParentParticipationInkind(staff); return(View(parentParticipation)); }
public JsonResult GetInkindOptionByFilterType(int filterType) { List <SelectListItem> inKindOptionList = new List <SelectListItem>(); inKindOptionList = new InKindData().GetInkindOptionByFilter(staff, filterType); return(Json(inKindOptionList, JsonRequestBehavior.AllowGet)); }
public JsonResult DeleteInkindActivity(string activityCode) { bool isResult = false; try { isResult = new InKindData().DeleteInkindActivity(staff, activityCode); } catch (Exception ex) { clsError.WriteException(ex); } return(Json(isResult, JsonRequestBehavior.AllowGet)); }
public JsonResult GetInkindActivities() { Inkind inkind = new Inkind(); try { inkind = new InKindData().GetInkindActivities(staff); } catch (Exception ex) { clsError.WriteException(ex); } return(Json(inkind, JsonRequestBehavior.AllowGet)); }
public ActionResult ParentParticipation() { ParentParticipation parentParticipation = new FingerprintsModel.ParentParticipation(); try { parentParticipation = new InKindData().GetParentParticipationInkind(StaffDetails.GetInstance()); } catch (Exception ex) { clsError.WriteException(ex); } return(View(parentParticipation)); }
public JsonResult DeleteInKindSubActivity(int subID) { bool returnResult = false; try { returnResult = new InKindData().DeleteInKindSubActivity(subID); } catch (Exception ex) { clsError.WriteException(ex); } return(Json(returnResult, JsonRequestBehavior.AllowGet)); }
public JsonResult InsertInkindTransactions(string modelString = "") { int returnResult = 0; long identityRet = 0; try { JavaScriptSerializer serializer = new JavaScriptSerializer(); Inkind model = new Inkind(); model = serializer.Deserialize <Inkind>(modelString); if (Session["UserID"] == null) { returnResult = 2; return(Json(returnResult, JsonRequestBehavior.AllowGet)); } if (model.InKindDonarsContact.IsInsert) { identityRet = new InKindData().InsertInKindDonors(model.InKindDonarsContact); if (identityRet > 0) { foreach (var item in model.InkindTransactionsList) { item.ParentID = identityRet.ToString(); item.InKindAmount = GetAmountByInkindType(item); returnResult = new InKindData().InsertInkindTransactions(item); } } } else { foreach (var item in model.InkindTransactionsList) { item.InKindAmount = GetAmountByInkindType(item); returnResult = new InKindData().InsertInkindTransactions(item); } } returnResult = (returnResult > 0) ? 1 : returnResult; return(Json(returnResult, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { clsError.WriteException(ex); return(Json(returnResult, JsonRequestBehavior.AllowGet)); } }
public JsonResult DeleteInkindAttachments(int attachmentId, int inkindTransactionId) { bool isResult = false; try { isResult = new InKindData().DeleteInkindAttachments(staff, attachmentId, inkindTransactionId); } catch (Exception ex) { clsError.WriteException(ex); } return(Json(isResult, JsonRequestBehavior.AllowGet)); }
public JsonResult ModifyInkindEntryPeriods(List <InkindPeriods> inkindPeriodList, Guid?targetAgencyId) { bool isResult = false; try { isResult = new InKindData().ModifyInkindEntryPeriodData(staff, inkindPeriodList, targetAgencyId); } catch (Exception ex) { clsError.WriteException(ex); } return(Json(isResult, JsonRequestBehavior.AllowGet)); }
public JsonResult GetParentCompanyDonorsBySearch(string searchName = "") { Inkind inkind = new Inkind(); try { StaffDetails staffDetails = StaffDetails.GetInstance(); inkind = new InKindData().GetInkindParentCompanyDonors(staffDetails, searchName); } catch (Exception ex) { clsError.WriteException(ex); } return(Json(inkind, JsonRequestBehavior.AllowGet)); }
public FileResult GetInkindAttachment(int attachmentId, int inkindTransactionId) { try { InkindAttachments inkindAttachments = new InKindData().GetInkindAttachmentData(staff, attachmentId, inkindTransactionId); string attachmentFormat = ""; switch (inkindAttachments.InkindAttachmentFileExtension) { case ".xlsx": attachmentFormat = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; break; case ".pdf": attachmentFormat = "application/pdf"; break; case ".jpg": attachmentFormat = "image/jpeg"; break; case ".png": attachmentFormat = "image/png"; break; case ".docx": attachmentFormat = "application/vnd.openxmlformats-officedocument.wordprocessingml.document"; break; case ".txt": attachmentFormat = "text/plain"; break; default: attachmentFormat = "application/octet-stream"; break; } return(File(inkindAttachments.InkindAttachmentFileByte, attachmentFormat)); } catch (Exception ex) { clsError.WriteException(ex); return(File(new byte[0], "")); } }
/// <summary> /// JsonResult method to get the Inkind Activity Details list /// </summary> /// <returns>Inkind</returns> public JsonResult GetInkindActivities() { Inkind inkind = new Inkind(); try { StaffDetails details = new StaffDetails(); //details.AgencyId = (Session["AgencyId"] == null) ? (Guid?)null : new Guid(Session["AgencyID"].ToString()); //details.UserId = new Guid(Session["UserID"].ToString()); //details.RoleId = new Guid(Session["RoleID"].ToString()); inkind = new InKindData().GetInkindActivities(details); } catch (Exception ex) { clsError.WriteException(ex); } return(Json(inkind, JsonRequestBehavior.AllowGet)); }
public JsonResult InsertParentParticipation(string transactionString = "", string parentID = "") { bool returnResult = false; try { ParentParticipation participation = new FingerprintsModel.ParentParticipation(); JavaScriptSerializer serializer = new JavaScriptSerializer(); participation.InKindTransactionsList = serializer.Deserialize <List <InKindTransactions> >(transactionString); returnResult = new InKindData().InsertParentParticipation(participation.InKindTransactionsList); } catch (Exception ex) { clsError.WriteException(ex); } return(Json(returnResult, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Deletes the Inkind Activity.Returns,Boolean JSON Result. /// </summary> /// <param name="activityCode"></param> /// <returns></returns> public JsonResult DeleteInkindActivity(string activityCode) { bool isResult = false; try { //StaffDetails details = new StaffDetails //{ // UserId = new Guid(Session["UserID"].ToString()), // RoleId = new Guid(Session["RoleID"].ToString()), // AgencyId = (Session["AgencyId"] == null) ? (Guid?)null : new Guid(Session["AgencyID"].ToString()) //}; StaffDetails details = StaffDetails.GetInstance(); isResult = new InKindData().DeleteInkindActivity(details, activityCode); } catch (Exception ex) { clsError.WriteException(ex); } return(Json(isResult, JsonRequestBehavior.AllowGet)); }
public Inkind GetInkindActivityFromTempData() { Inkind _tempinkindDetails = new Inkind(); try { if (Session["Inkind"] != null) { _tempinkindDetails = (Inkind)Session["Inkind"]; } else { _tempinkindDetails = new InKindData().GetInkindActivities(staff); Session["Inkind"] = _tempinkindDetails; } } catch (Exception ex) { clsError.WriteException(ex); } return(_tempinkindDetails); }
public JsonResult AutoCompleteInkindTransactions(int filterType, string selectedOption, string centers, string fromDate, string toDate, int requestedPage, int pageSize, string sortOrder, string sortColumn, string searchTerm, string searchTermType) { InkindReportModel inkindReportmodel = new InkindReportModel(); inkindReportmodel.RequestedPage = requestedPage; inkindReportmodel.PageSize = pageSize; inkindReportmodel.SkipRows = inkindReportmodel.GetSkipRows(); inkindReportmodel.FilterTypeEnum = EnumHelper.GetEnumByStringValue <FingerprintsModel.Enums.InkindReportFilter>(filterType.ToString()); inkindReportmodel.FromDate = fromDate; inkindReportmodel.ToDate = toDate; inkindReportmodel.SortColumn = sortColumn.ToUpperInvariant(); inkindReportmodel.SortOrder = sortOrder; inkindReportmodel.SubFilterOption = selectedOption; inkindReportmodel.Centers = centers; inkindReportmodel.SearchTerm = searchTerm; //inkindReportmodel.SearchFilterType = searchFilterType; List <SelectListItem> inkindSearchList = new InKindData().AutoCompleteInkindTransactionData(inkindReportmodel, staff); return(Json(inkindSearchList, JsonRequestBehavior.AllowGet)); }
public JsonResult DeleteInkindTransactions(string inkindTransactionId) { bool isResult = false; try { InKindTransactions inkindTransactions = new InKindTransactions(); inkindTransactions.IsActive = false; inkindTransactions.InkindTransactionID = Convert.ToInt32(EncryptDecrypt.Decrypt64(inkindTransactionId)); inkindTransactions.StaffSignature = inkindTransactions.StaffSignature ?? new StaffSignature(); isResult = new InKindData().InsertInkindTransactions(inkindTransactions) > 0; } catch (Exception ex) { clsError.WriteException(ex); } return(Json(isResult, JsonRequestBehavior.AllowGet)); }
public JsonResult GetInkindTransactions(string transactionId) { Inkind inkind = new Inkind(); transactionId = EncryptDecrypt.Decrypt64(transactionId); inkind = new InKindData().GetInkindTransactions(staff, transactionId); bool isCenterBased = false; bool isHomeBased = false; //if (inkind != null && inkind.InkindActivityList != null && inkind.InkindActivityList.Count > 0) //{ // isCenterBased = Convert.ToInt32(inkind.InkindActivityList[0].ActivityType) == (int)FingerprintsModel.Enums.InkindActivityType.Center; // isHomeBased = Convert.ToInt32(inkind.InkindActivityList[0].ActivityType) == (int)FingerprintsModel.Enums.InkindActivityType.HomeBased; //} List <SelectListItem> centerList = Utilities.Helper.GetCentersByUserId(staff.UserId.ToString(), staff.AgencyId.ToString(), staff.RoleId.ToString(), isCenterBasedOnly: isCenterBased, isHomebasedonly: isHomeBased); centerList.ForEach(x => x.Value = EncryptDecrypt.Encrypt64(x.Value)); return(Json(new { inkind, centerList }, JsonRequestBehavior.AllowGet)); }
public JsonResult CheckInKindRecordExistsByDate(string startDate, string endDate, Guid?targetAgencyId, long inkindPeriodID) { bool isExists = new InKindData().CheckInKindRecordExistsData(staff, startDate, endDate, targetAgencyId, inkindPeriodID); return(Json(isExists, JsonRequestBehavior.AllowGet)); }
public JsonResult GetInkindPeriods(Guid?targetAgencyId) { List <InkindPeriods> inkindPeriodList = new InKindData().GetInkindPeriodsDate(staff, targetAgencyId); return(Json(inkindPeriodList, JsonRequestBehavior.AllowGet)); }
public JsonResult InsertInkindTransactions(string modelString = "", string cameraUploads = null) //public JsonResult InsertInkindTransactions(Inkind _inkind) { int returnResult = 0; long identityRet = 0; try { JavaScriptSerializer serializer = new JavaScriptSerializer(); serializer.MaxJsonLength = Int32.MaxValue; Inkind model = new Inkind(); model = serializer.Deserialize <Inkind>(modelString); var fileKeys = Request.Files.AllKeys; model.InkindTransactionsList[0].InkindAttachmentsList = new List <InkindAttachments>(); var count = model.InkindTransactionsList.Count; if (count == 1) { for (int i = 0; i < fileKeys.Length; i++) { model.InkindTransactionsList[0].InkindAttachmentsList.Add(new InkindAttachments { InkindAttachmentFile = Request.Files[i], InkindAttachmentFileName = Request.Files[i].FileName, InkindAttachmentFileExtension = Path.GetExtension(Request.Files[i].FileName), InkindAttachmentFileByte = new BinaryReader(Request.Files[i].InputStream).ReadBytes(Request.Files[i].ContentLength) }); } if (!string.IsNullOrEmpty(cameraUploads)) { List <SelectListItem> cameraUplodList = serializer.Deserialize <List <SelectListItem> >(cameraUploads); foreach (var item in cameraUplodList) { model.InkindTransactionsList[0].InkindAttachmentsList.Add(new InkindAttachments { //InkindAttachmentFile = Convert.FromBase64String(item.Value), InkindAttachmentFileName = item.Text, InkindAttachmentFileExtension = ".png", InkindAttachmentFileByte = Convert.FromBase64String(item.Value) }); } } } if (Session["UserID"] == null) { returnResult = 2; return(Json(returnResult, JsonRequestBehavior.AllowGet)); } if (model.InKindDonarsContact.IsInsert) { identityRet = new InKindData().InsertInKindDonors(model.InKindDonarsContact); if (identityRet > 0) { foreach (var item in model.InkindTransactionsList) { item.ParentID = identityRet.ToString(); item.InKindAmount = GetAmountByInkindType(item); item.CenterID = (item.CenterID > 0) ? item.CenterID : !string.IsNullOrEmpty(item.Enc_CenterID) ? Convert.ToInt32(EncryptDecrypt.Decrypt64(item.Enc_CenterID)) : item.CenterID; item.ClassroomID = (item.ClassroomID > 0) ? item.ClassroomID : !string.IsNullOrEmpty(item.Enc_ClassroomID) ? Convert.ToInt32(EncryptDecrypt.Decrypt64(item.Enc_ClassroomID)) : item.ClassroomID; item.IsActive = true; item.StaffSignature = item.StaffSignature ?? new StaffSignature(); returnResult = new InKindData().InsertInkindTransactions(item); } } } else { foreach (var item in model.InkindTransactionsList) { item.InKindAmount = GetAmountByInkindType(item); item.CenterID = (item.CenterID > 0) ? item.CenterID : !string.IsNullOrEmpty(item.Enc_CenterID) ? Convert.ToInt32(EncryptDecrypt.Decrypt64(item.Enc_CenterID)) : item.CenterID; item.ClassroomID = (item.ClassroomID > 0) ? item.ClassroomID : !string.IsNullOrEmpty(item.Enc_ClassroomID) ? Convert.ToInt32(EncryptDecrypt.Decrypt64(item.Enc_ClassroomID)) : item.ClassroomID; item.IsActive = true; item.StaffSignature = item.StaffSignature ?? new StaffSignature(); returnResult = new InKindData().InsertInkindTransactions(item); } } returnResult = (returnResult > 0) ? 1 : returnResult; return(Json(returnResult, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { clsError.WriteException(ex); return(Json(returnResult, JsonRequestBehavior.AllowGet)); } }