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