/// <summary>
/// Creator: Awaab Elamin
/// Created: 02/05/2020
/// Approver: Mohamed Elamin, 2/21/2020
///
/// retrieve all Adoption Apllications
/// </summary>
/// <remarks>
/// Updater:
/// Updated:
/// Update:
/// </remarks>
/// <param name="questionnair"></param>
/// <returns></returns>
public bool inserQuestionnair(Questionnair questionnair)
{
bool result = false;
int count = customerQuestionnars.Count;
CustomerQuestionnar customerQuestionnair = new CustomerQuestionnar();
customerQuestionnair.QuestionDescription = questionnair.Question1;
customerQuestionnair.Answer = questionnair.Answer1;
customerQuestionnars.Add(customerQuestionnair);
customerQuestionnair.QuestionDescription = questionnair.Question2;
customerQuestionnair.Answer = questionnair.Answer2;
customerQuestionnars.Add(customerQuestionnair);
customerQuestionnair.QuestionDescription = questionnair.Question2;
customerQuestionnair.Answer = questionnair.Answer2;
customerQuestionnars.Add(customerQuestionnair);
customerQuestionnair.QuestionDescription = questionnair.Question3;
customerQuestionnair.Answer = questionnair.Answer3;
customerQuestionnars.Add(customerQuestionnair);
customerQuestionnair.QuestionDescription = questionnair.Question4;
customerQuestionnair.Answer = questionnair.Answer4;
customerQuestionnars.Add(customerQuestionnair);
customerQuestionnair.QuestionDescription = questionnair.Question5;
customerQuestionnair.Answer = questionnair.Answer5;
customerQuestionnars.Add(customerQuestionnair);
customerQuestionnair.QuestionDescription = questionnair.Question6;
customerQuestionnair.Answer = questionnair.Answer6;
customerQuestionnars.Add(customerQuestionnair);
customerQuestionnair.QuestionDescription = questionnair.Question7;
customerQuestionnair.Answer = questionnair.Answer7;
customerQuestionnars.Add(customerQuestionnair);
customerQuestionnair.QuestionDescription = questionnair.Question8;
customerQuestionnair.Answer = questionnair.Answer8;
customerQuestionnars.Add(customerQuestionnair);
customerQuestionnair.QuestionDescription = questionnair.Question9;
customerQuestionnair.Answer = questionnair.Answer9;
customerQuestionnars.Add(customerQuestionnair);
customerQuestionnair.QuestionDescription = questionnair.Question10;
customerQuestionnair.Answer = questionnair.Answer10;
customerQuestionnars.Add(customerQuestionnair);
if ((count + 10) == (customerQuestionnars.Count))
{
result = true;
}
return(result);
}
/// <summary>
/// Creator: Awaab Elamin
/// Created: 2020/02/15
/// Approver: Mohamed Elamin
/// retrieve Customer Questionnair record from customers Questionnairs table by his ID.
/// </summary>
/// <remarks>
/// Updater: Mohamed Elamin
/// Updated: 2020/04/21
/// Update: Fixed comments format.
/// </remarks>
/// <param name="customerID"></param>
/// <returns>customerQuestionnars</returns>
public List <CustomerQuestionnar> getCustomerQuestionnair(string customerEmail)
{
List <CustomerQuestionnar> customerQuestionnars = new List <CustomerQuestionnar>();
var conn = DBConnection.GetConnection();
string cmdText = @"sp_get_Customer_Answer_By_CustomrEmail";
var cmd = new SqlCommand(cmdText, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CustomerEmail", customerEmail);
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
CustomerQuestionnar customerQuestionnar
= new CustomerQuestionnar();
customerQuestionnar.QuestionDescription = reader.GetString(0);
customerQuestionnar.Answer = reader.GetString(1);
customerQuestionnars.Add(customerQuestionnar);
}
reader.Close();
}
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
return(customerQuestionnars);
}
