public Result <FPQsnAns> SaveCustomer(FPQsnAns qs)
{
var result = new Result <FPQsnAns>();
string query = "select * from customer where customer_no = '" + qs.question_no + "'";
var dt = DataAccess.GetDataTable(query);
if (dt == null || dt.Rows.Count == 0)
{
query = "Insert into fp_question_answer values ('" + qs.question + "','" + qs.answer + "')";
}
else
{
query = "Update fp_question_answer set question = '" + qs.question + "',answer='" + qs.answer + "' where question_no=" + qs.question_no + ";";
}
result.HasError = DataAccess.ExecuteQuery(query) <= 0;
if (result.HasError)
{
result.Message = "Wrong";
}
else
{
result.Data = qs;
}
return(result);
}
private FPQsnAns ConvertToEntity(DataRow row)
{
if (row == null)
{
return(null);
}
FPQsnAns qs = new FPQsnAns();
qs.question_no = int.Parse(row["question_no"].ToString());
qs.question = row["question"].ToString();
qs.answer = row["answer"].ToString();
return(qs);
}
public Result <FPQsnAns> DeleteCustomer(FPQsnAns e, string a)
{
var result = new Result <FPQsnAns>();
string query = "delete from fp_question_answer where question_no = " + a + ";";
result.HasError = DataAccess.ExecuteQuery(query) <= 0;
if (result.HasError)
{
result.Message = "Wrong";
}
else
{
result.Data = e;
}
return(result);
}
public Result <List <FPQsnAns> > GetAllQuestion()
{
var result = new Result <List <FPQsnAns> >()
{
Data = new List <FPQsnAns>()
};
try
{
string query = "Select * from fp_question_answer";
var dt = DataAccess.GetDataTable(query);
for (int i = 0; i < dt.Rows.Count; i++)
{
FPQsnAns qs = ConvertToEntity(dt.Rows[i]);
result.Data.Add(qs);
}
}
catch (Exception exc)
{
result.HasError = true;
result.Message = exc.Message;
}
return(result);
}
