/// <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);
}
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));
}
/// <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 DataTable GetSubActivitiesTable(InkindActivity activity)
{
DataTable activityTable = new DataTable();
try
{
activityTable.Clear();
activityTable.Columns.AddRange(new DataColumn[9] {
new DataColumn("SubActivityId", typeof(long)),
new DataColumn("AgencyId", typeof(Guid)),
new DataColumn("ActivityCode", typeof(int)),
new DataColumn("ActivityDescription ", typeof(string)),
new DataColumn("IsActive", typeof(bool)),
new DataColumn("CreatedBy", typeof(Guid)),
new DataColumn("CreatedDate", typeof(DateTime))
{
AllowDBNull = true
},
new DataColumn("ModifiedBy", typeof(Guid))
{
AllowDBNull = true
},
new DataColumn("ModifiedDate", typeof(DateTime))
{
AllowDBNull = true
}
});
if (activity.SubActivityList.Count() > 0)
{
foreach (var item in activity.SubActivityList)
{
item.ActivityCode = string.IsNullOrEmpty(activity.ActivityCode) ? 0 : Convert.ToInt32(activity.ActivityCode);
activityTable.Rows.Add(
item.SubActivityId,
activity.StaffDetails.AgencyId,
item.ActivityCode,
item.ActivityDescription,
item.IsActive,
activity.StaffDetails.UserId,
(DateTime?)null,
(Guid?)null,
(DateTime?)null
);
}
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(activityTable);
}
public bool InsertInkindActivity(InkindActivity activity)
{
bool isRowsAffected = false;
try
{
int rowsAffected = 0;
DataTable actb = new DataTable();
actb = this.GetSubActivitiesTable(activity);
using (_connection)
{
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@AgencyId", activity.StaffDetails.AgencyId));
command.Parameters.Add(new SqlParameter("@UserId", activity.StaffDetails.UserId));
command.Parameters.Add(new SqlParameter("@RoleId", activity.StaffDetails.RoleId));
command.Parameters.Add(new SqlParameter("@ActivityType", activity.ActivityType));
command.Parameters.Add(new SqlParameter("@AmountType", activity.ActivityAmountType));
command.Parameters.Add(new SqlParameter("@Rate", activity.ActivityAmountRate));
command.Parameters.Add(new SqlParameter("@IsSignatureRequired", activity.IsSignatureRequired));
command.Parameters.Add(new SqlParameter("@ActivityDescription", activity.ActivityDescription));
command.Parameters.Add(new SqlParameter("@ActivityCode", string.IsNullOrEmpty(activity.ActivityCode) ? "0" : activity.ActivityCode));
command.Parameters.Add(new SqlParameter("@Volunteer", activity.Volunteer));
command.Parameters.Add(new SqlParameter("@SubActivities", actb));
command.CommandText = "USP_InsertInkindActivity";
command.CommandType = CommandType.StoredProcedure;
command.Connection = _connection;
_connection.Open();
rowsAffected = command.ExecuteNonQuery();
_connection.Close();
}
isRowsAffected = (rowsAffected > 0);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
command.Dispose();
_connection.Dispose();
}
return(isRowsAffected);
}
/// <summary>
/// method to check whether In-Kind Activity is already exists in the database based on agencyId.
/// </summary>
/// <param name="activity"></param>
/// <returns></returns>
public string CheckActivityExists(InkindActivity activity)
{
string executeRecord = "";
try
{
using (_connection)
{
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@AgencyId", activity.StaffDetails.AgencyId));
command.Parameters.Add(new SqlParameter("@UserId", activity.StaffDetails.UserId));
command.Parameters.Add(new SqlParameter("@RoleId", activity.StaffDetails.RoleId));
command.Parameters.Add(new SqlParameter("@ActivityType", activity.ActivityType));
command.Parameters.Add(new SqlParameter("@AmountType", activity.ActivityAmountType));
command.Parameters.Add(new SqlParameter("@Rate", activity.ActivityAmountRate));
command.Parameters.Add(new SqlParameter("@IsSignatureRequired", activity.IsSignatureRequired));
command.Parameters.Add(new SqlParameter("@ActivityCode", string.IsNullOrEmpty(activity.ActivityCode) ? "0" : activity.ActivityCode));
command.Parameters.Add(new SqlParameter("@ActivityDescription", activity.ActivityDescription));
command.CommandText = "USP_CheckInkindActivityExists";
command.CommandType = CommandType.StoredProcedure;
command.Connection = _connection;
_connection.Open();
executeRecord = Convert.ToString(command.ExecuteScalar());
_connection.Close();
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
command.Dispose();
_connection.Dispose();
}
return(executeRecord);
}
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));
}
