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