public ActionResult InKindEntry()
{
Inkind inkind = new Inkind();
try
{
inkind = GetInkindActivityFromTempData();
if (inkind != null && inkind.InkindPeriodsList != null && inkind.InkindPeriodsList.Count > 0)
{
inkind.InkindPeriodsList = inkind.InkindPeriodsList.Where(x => x.IsClosed == false).ToList();
}
//StaffDetails details = StaffDetails.GetInstance();
//inkind = new InKindData().GetInkindActivities(details);
//TempData["Inkind"] = inkind;
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(View(inkind));
}
/// <summary>
/// Method to set the Activity Amount for Parent
/// </summary>
/// <param name="transactionsList"></param>
/// <returns>List<InKindTransactions></returns>
public List <InKindTransactions> SetActivityAmtForParent(List <InKindTransactions> transactionsList)
{
//List<InKindTransactions> transList = new List<InKindTransactions>();
//transList = transactionsList;
try
{
Inkind inkind = new Inkind();
StaffDetails details = StaffDetails.GetInstance();
inkind = new InKindData().GetInkindActivities(details);
if (inkind.InkindActivityList.Count() > 0 && transactionsList != null && transactionsList.Count() > 0)
{
foreach (var item in transactionsList)
{
item.ParentID = EncryptDecrypt.Decrypt64(item.ParentID);
string actvitytype = "";
string ActivityAmountRate = "";
if (item.ActivityID > 0)
{
actvitytype = inkind.InkindActivityList.Where(x => x.ActivityCode == item.ActivityID.ToString()).Select(x => x.ActivityType).FirstOrDefault();
}
if (actvitytype == "2" || item.ActivityID == 0)
{
actvitytype = (actvitytype == "") ? (item.Hours > 0 || item.Minutes > 0) ? "2" : (item.MilesDriven > 0) ? "1" : actvitytype : actvitytype;
item.ActivityID = inkind.InkindActivityList.Where(x => x.ActivityType == actvitytype).Select(x => Convert.ToInt32(x.ActivityCode)).FirstOrDefault();
ActivityAmountRate = inkind.InkindActivityList.Where(x => x.ActivityCode == item.ActivityID.ToString()).Select(x => x.ActivityAmountRate).FirstOrDefault();
}
else
{
ActivityAmountRate = inkind.InkindActivityList.Where(x => x.ActivityCode == item.ActivityID.ToString()).Select(x => x.ActivityAmountRate).FirstOrDefault();
}
if (item.Hours > 0 || item.Minutes > 0)
{
// var InKindAmount1 = Convert.ToDouble(ActivityAmountRate) * (4 + (45 / 60));//46.56
item.InKindAmount = Convert.ToDecimal((Convert.ToDouble(ActivityAmountRate) * (item.Hours + (item.Minutes / 60))).ToString("F", CultureInfo.InvariantCulture));
}
}
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(transactionsList);
}
public JsonResult SaveInkind(Inkind inkind)
{
bool isResult = false;
try
{
isResult = new ExecutiveData().SaveInkind(inkind, Session["AgencyID"].ToString(), Session["UserID"].ToString());
}
catch (Exception Ex)
{
clsError.WriteException(Ex);
}
return(Json(isResult));
}
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 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 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 bool SaveInkind(Inkind inkind, string AgencyId, string UserId)
{
bool isInserted = false;
try
{
command = new SqlCommand();
if (!string.IsNullOrEmpty(inkind.Id))
{
command.Parameters.Add(new SqlParameter("@Id", inkind.Id));
}
command.Parameters.Add(new SqlParameter("@AgencyId", AgencyId));
command.Parameters.Add(new SqlParameter("@UserId", UserId));
command.Parameters.Add(new SqlParameter("@ProgramYear", inkind.ProgramYear));;
command.Parameters.Add(new SqlParameter("@Hours", inkind.Hours));
command.Parameters.Add(new SqlParameter("@Budget", inkind.Dollers));
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "USP_AddInkindBudget";
if (Connection.State == ConnectionState.Open)
{
Connection.Close();
}
Connection.Open();
int RowsAffected = command.ExecuteNonQuery();
if (RowsAffected > 0)
{
isInserted = true;
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
if (Connection != null)
{
Connection.Close();
}
}
return(isInserted);
}
/// <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 ActionResult PublicAssetEntry()
{
Inkind inkind = new Inkind();
try
{
inkind = GetInkindActivityFromTempData();
//StaffDetails details = StaffDetails.GetInstance();
//inkind = new InKindData().GetInkindActivities(details);
//TempData["Inkind"] = inkind;
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(View(inkind));
}
public JsonResult GetActivityByActivityType(int activitytype)
{
Inkind inKindData = new Inkind();
try
{
inKindData = GetInkindActivityFromTempData();
//if (inKindData != null)
//{
// if (inKindData.InkindActivityList.Count() > 0)
// {
// inKindData.InkindActivityList = inKindData.InkindActivityList.Where(x => x.ActivityType == activitytype.ToString()).ToList();
// }
//}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(inKindData, 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 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));
}
/// <summary>
/// Get the existing In-kind Parent or Company Donors based on agency from the database.
/// </summary>
/// <param name="staffDetails">StafDetails</param>
/// <param name="searchText">string</param>
/// <returns>Inkind</returns>
public Inkind GetInkindParentCompanyDonors(StaffDetails staffDetails, string searchText)
{
Inkind inkind = new Inkind();
inkind.InkindDonorsList = new List <InkindDonors>();
try
{
using (_connection)
{
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@AgencyId", staffDetails.AgencyId));
command.Parameters.Add(new SqlParameter("@UserId", staffDetails.UserId));
command.Parameters.Add(new SqlParameter("@RoleId", staffDetails.RoleId));
command.Parameters.Add(new SqlParameter("@SearchText", searchText));
command.Connection = _connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "USP_GetInkindDonors";
_connection.Open();
dataset = new DataSet();
adapter = new SqlDataAdapter(command);
adapter.Fill(dataset);
_connection.Close();
if (dataset != null && dataset.Tables.Count > 0)
{
inkind.InkindDonorsList = (from DataRow dr in dataset.Tables[0].Rows
select new InkindDonors
{
Name = dr["Name"].ToString(),
EmailAddress = dr["EmailId"].ToString(),
Address = dr["Address"].ToString(),
State = dr["State"].ToString(),
ZipCode = dr["ZipCode"].ToString(),
InkindDonorId = dr["ClientId"].ToString(),
CompanyName = dr["CompanyName"].ToString(),
PhoneNoList = (dataset.Tables[1].Rows.Count > 0) ?
(from DataRow dr2 in dataset.Tables[1].Rows
where (Convert.ToInt64(dr2["ClientId"]) == Convert.ToInt64(dr["ClientId"]))
select new FamilyHousehold.phone
{
PhoneNo = dr2["Phoneno"].ToString(),
PhoneType = dr2["PhoneType"].ToString(),
ParentId = Convert.ToInt64(dr2["ClientId"])
}
).ToList() : new List <FamilyHousehold.phone>(),
}
).ToList();
}
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
command.Dispose();
_connection.Dispose();
dataset.Dispose();
}
return(inkind);
}
/// <summary>
/// Gets the In-Kind Activities List based on the AgencyId.
/// </summary>
/// <param name="details"></param>
/// <returns>Inkind class</returns>
public Inkind GetInkindActivities(StaffDetails details, int activityCode = 0, int amountType = 0, bool getVolunteerBased = false, int activityType = 0)
{
Inkind inkindDetails = new Inkind();
int rowscount = 0;
inkindDetails.InkindActivityList = new List <InkindActivity>();
try
{
using (_connection)
{
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@AgencyId", details.AgencyId));
command.Parameters.Add(new SqlParameter("@UserId", details.UserId));
command.Parameters.Add(new SqlParameter("@RoleId", details.RoleId));
command.Parameters.Add(new SqlParameter("@ActivityCode", activityCode));
command.Parameters.Add(new SqlParameter("@AmountType", amountType));
command.Parameters.Add(new SqlParameter("@GetVolunteerBased", getVolunteerBased));
command.Parameters.Add(new SqlParameter("@ActivityType", activityType));
command.CommandType = CommandType.StoredProcedure;
command.Connection = _connection;
command.CommandText = "USP_GetInkindActivities";
_connection.Open();
adapter = new SqlDataAdapter(command);
dataset = new DataSet();
adapter.Fill(dataset);
_connection.Close();
}
if (dataset != null)
{
if (dataset.Tables[0].Rows.Count > 0)
{
inkindDetails.InkindActivityList = (from DataRow dr in dataset.Tables[0].Rows
select new InkindActivity
{
ActivityAmountRate = dr["Rate"].ToString(),
ActivityDescription = dr["ActivityDescription"].ToString(),
ActivityAmountType = dr["AmountyType"].ToString(),
ActivityCode = dr["ActivityCode"].ToString(),
Volunteer = Convert.ToBoolean(dr["Volunteer"]),
ActivityType = dr["ActivityType"].ToString(),
IsSignatureRequired = Convert.ToBoolean(dr["IsSignatureRequired"]),
SubActivityList = (int.TryParse(dataset.Tables[1].Rows.Count.ToString(), out rowscount)) ? (from DataRow dr1 in dataset.Tables[1].Rows
where Convert.ToInt32(dr1["ActivityCode"]) == Convert.ToInt32(dr["ActivityCode"])
select new SubActivities
{
ActivityCode = Convert.ToInt32(dr1["ActivityCode"]),
SubActivityId = Convert.ToInt64(dr1["SubActivityId"]),
ActivityDescription = dr1["ActivityDescription"].ToString()
}).ToList() : new List <SubActivities>()
}
).ToList();
}
if (dataset.Tables.Count > 2)
{
inkindDetails.HomeActivityCount = Convert.ToInt32(dataset.Tables[2].Rows[0]["HomeActivityCount"]);
}
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
dataset.Dispose();
_connection.Dispose();
}
return(inkindDetails);
}
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));
}
}
public JsonResult GetDetailsByActivityType(string activityCode, int reqDetails, string hours = "0", string minutes = "0", string miles = "0")
{
string returnDetails = string.Empty;
double dblMiles = 0;
double dblhours = 0;
double dblMinutes = 0;
Inkind inkind = new Inkind();
InkindActivity activity = new InkindActivity();
List <InkindActivity> activtyList = new List <InkindActivity>();
List <string> activityCodeList = new List <string>();
try
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
activityCodeList = serializer.Deserialize <List <string> >(activityCode);
activtyList = GetInkindActivityFromTempData().InkindActivityList;
// inkind=new InKindData().GetInkindActivities(new StaffDetails(),)
activityCodeList = activityCodeList.Distinct().ToList();
if (activityCodeList.Count() > 0)
{
activity.ActivityAmount = "0";
string activityAmount = "0";
foreach (string actCode in activityCodeList)
{
if (reqDetails == 1) //for Amount Type
{
activity = activtyList.Where(x => x.ActivityCode == actCode).FirstOrDefault();
}
else if (reqDetails == 2)//Amount Rate Calculation
{
activity = activtyList.Where(x => x.ActivityCode == actCode).FirstOrDefault();
double.TryParse(miles, out dblMiles);
double.TryParse(hours, out dblhours);
double.TryParse(minutes, out dblMinutes);
if (dblMiles > 0 && activity.ActivityAmountType == "1")
{
activityAmount = (Convert.ToDouble(activityAmount) + (Convert.ToDouble(activity.ActivityAmountRate) * dblMiles)).ToString("F", CultureInfo.InvariantCulture);
}
else if ((dblhours > 0 || dblMinutes > 0) && activity.ActivityAmountType == "2")
{
activityAmount = (Convert.ToDouble(activityAmount) + (Convert.ToDouble(activity.ActivityAmountRate) * (dblhours + (dblMinutes / 60)))).ToString("F", CultureInfo.InvariantCulture);
}
//else if (activity.ActivityAmountType == "3")
//{
// // activity.ActivityAmount = (activity.ActivityAmount == "0") ? "" : activity.ActivityAmount;
// activityAmount = activity.ActivityAmount;
//}
}
}
activity.ActivityAmount = activityAmount;
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(activity, JsonRequestBehavior.AllowGet));
}
