/// <summary>
/// method to insert the Inkind/Asset Entry by parent or Corporate to the database.
/// </summary>
/// <param name="inkindTransactions"></param>
/// <returns></returns>
public int InsertInkindTransactions(InKindTransactions inkindTransactions)
{
int rowsAffected = 0;
try
{
StaffDetails details = StaffDetails.GetInstance();
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("@ChildId", inkindTransactions.ClientID));
command.Parameters.Add(new SqlParameter("@ParentId", inkindTransactions.ParentID));
command.Parameters.Add(new SqlParameter("@ActivityDate", inkindTransactions.ActivityDate));
command.Parameters.Add(new SqlParameter("@CenterID", inkindTransactions.CenterID));
command.Parameters.Add(new SqlParameter("@ClassroomID", inkindTransactions.ClassroomID));
command.Parameters.Add(new SqlParameter("@ActivityID", inkindTransactions.ActivityID));
command.Parameters.Add(new SqlParameter("@hours", inkindTransactions.Hours));
command.Parameters.Add(new SqlParameter("@minutes", inkindTransactions.Minutes));
command.Parameters.Add(new SqlParameter("@ActivityNotes", inkindTransactions.ActivityNotes));
command.Parameters.Add(new SqlParameter("@IsCompany", inkindTransactions.IsCompany));
command.Parameters.Add(new SqlParameter("@DonorSignature", inkindTransactions.DonorSignature));
command.Parameters.Add(new SqlParameter("@StaffSignature", inkindTransactions.StaffSignature));
command.Parameters.Add(new SqlParameter("@InKindAmount", inkindTransactions.InKindAmount));
command.Parameters.Add(new SqlParameter("@MilesDriven", inkindTransactions.MilesDriven));
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SP_MarkInkindActivity";
command.Connection = _connection;
_connection.Open();
rowsAffected = command.ExecuteNonQuery();
_connection.Close();
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
command.Dispose();
_connection.Dispose();
dataset.Dispose();
}
return(rowsAffected);
}
public decimal GetAmountByInkindType(InKindTransactions transactions)
{
decimal inkindAmount = 0;
try
{
//Inkind inkindAMt = new Inkind();
List <InkindActivity> activityListInkind = new List <InkindActivity>();
activityListInkind = GetInkindActivityFromTempData().InkindActivityList;
if (activityListInkind.Count() > 0)
{
activityListInkind = activityListInkind.Where(x => x.ActivityCode == transactions.ActivityID.ToString()).ToList();
var sess = Session["Inkind"];
if (activityListInkind.Count() > 0)
{
foreach (var item in activityListInkind)
{
if (item.ActivityAmountType == "1") //Miles
{
inkindAmount = Convert.ToDecimal((Convert.ToDouble(inkindAmount) + (Convert.ToDouble(item.ActivityAmountRate) * Convert.ToDouble(transactions.MilesDriven))).ToString("F", CultureInfo.InvariantCulture));
}
else if (item.ActivityAmountType == "2")//Hours
{
inkindAmount = Convert.ToDecimal((Convert.ToDouble(inkindAmount) + (Convert.ToDouble(item.ActivityAmountRate) * (transactions.Hours + (transactions.Minutes / 60)))).ToString("F", CultureInfo.InvariantCulture));
}
else if (item.ActivityAmountType == "3")//fixed
{
//inkindAmount = Convert.ToDecimal(item.ActivityAmountRate);
inkindAmount = Convert.ToDecimal(transactions.InKindAmount);
}
}
}
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(inkindAmount);
}
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));
}
