private string UpdateSurvey(object data, int ID)
{
SurveyDataModel survey = jsonHelper.FromJson <SurveyDataModel>(data.ToString());
if (!string.IsNullOrEmpty(jsonHelper.ErrorMessage))
{
return(jsonHelper.ErrorMessage);
}
string result = "Error - No changes made";
List <SurveyDataModel> existingSurveys = surveyService.GetSurveys(); //Create list of existing surveys
SurveyDataModel surveyMatch = new SurveyDataModel();
if (existingSurveys != null)
{
surveyMatch = existingSurveys.Find(o => o.SurveyID.Equals(ID));
if (surveyMatch != null) //If survey is found
{
survey.SurveyID = surveyMatch.SurveyID;
if (surveyService.UpdateSurvey(survey))
{
result = "Successfully updated survey";
}
}
}
return(result);
}
public async Task <ActionResult> Create(IFormCollection collection)
{
string SurveyName = collection["SurveyName"];
int UserID = int.Parse(collection["UserID"]);
string Type = collection["Type"];
string Description = collection["Description"];
DateTime StartDate = Convert.ToDateTime(collection["StartDate"]);
DateTime EndDate = Convert.ToDateTime(collection["EndDate"]);
string Permission = collection["Permission"];
var survey = new SurveyDataModel
{
SurveyName = SurveyName,
UserID = UserID,
Type = Type,
Description = Description,
StartDate = StartDate,
EndDate = EndDate,
Permission = Permission
};
api.Client().BaseAddress = new Uri(baseAddress);
HttpResponseMessage response = await api.Client().PostAsJsonAsync("api/survey/save", survey);
response.EnsureSuccessStatusCode();
return(RedirectToAction("Index", "Survey"));
}
public bool AddNewSurvey(SurveyDataModel survey)
{
bool result = false;
if (survey != null)
{
string SqlQuery = "INSERT INTO Survey (survey_name, userID, type, description, start_date, end_date, permission) VALUES (@survey_name, @userID, @type, @description, @start_date, @end_date, @permission)";
try
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = CONNECTION_STRING;
conn.Open();
SqlCommand command = new SqlCommand(SqlQuery, conn);
if (SqlQuery.Length > 0)
{
command = new SqlCommand(SqlQuery, conn);
command.Parameters.AddWithValue("@survey_name", survey.SurveyName = survey.SurveyName ?? "");
command.Parameters.AddWithValue("@userID", survey.UserID);
command.Parameters.AddWithValue("@type", survey.Type = survey.Type ?? "");
command.Parameters.AddWithValue("@description", survey.Description = survey.Description ?? "");
command.Parameters.AddWithValue("@start_date", survey.StartDate);
command.Parameters.AddWithValue("@end_date", survey.EndDate);
command.Parameters.AddWithValue("@permission", survey.Permission = survey.Permission ?? "");
}
int sqlResult = command.ExecuteNonQuery();
result = sqlResult < 0 ? false : true;
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception Caught - " + ex.Message);
}
}
if (!result)
{
System.Diagnostics.Debug.WriteLine("Error - record not saved to database");
}
return(result);
}
private string AddNewSurvey(object data)
{
SurveyDataModel survey = jsonHelper.FromJson <SurveyDataModel>(data.ToString());
if (!string.IsNullOrEmpty(jsonHelper.ErrorMessage))
{
return(jsonHelper.ErrorMessage);
}
string result = "Error - No changes made";
if (surveyService.AddNewSurvey(survey))
{
result = "Successfully added new survey";
}
return(result);
}
public void CleanUp()
{
DataModel = new SurveyDataModel();
}
