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