public int SaveFAQs(faqs fi)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsUpdDelFAQs";
SqlParameter id = new SqlParameter("@Id", SqlDbType.Int);
id.Value = fi.Id;
cmd.Parameters.Add(id);
SqlParameter q = new SqlParameter("@Question", SqlDbType.VarChar, 100);
q.Value = fi.Question;
cmd.Parameters.Add(q);
SqlParameter a = new SqlParameter("@Answer", SqlDbType.VarChar, 500);
a.Value = fi.Answer;
cmd.Parameters.Add(a);
SqlParameter cb = new SqlParameter("@CreatedBy", SqlDbType.VarChar, 50);
cb.Value = fi.CreatedBy;
cmd.Parameters.Add(cb);
SqlParameter at = new SqlParameter("@AppType", SqlDbType.Int);
at.Value = fi.AppType;
cmd.Parameters.Add(at);
SqlParameter c = new SqlParameter("@Category", SqlDbType.Int);
c.Value = fi.Category;
cmd.Parameters.Add(c);
SqlParameter sc = new SqlParameter("@SubCategory", SqlDbType.Int);
sc.Value = fi.SubCategory;
cmd.Parameters.Add(sc);
SqlParameter f = new SqlParameter("@flag", SqlDbType.VarChar);
f.Value = fi.flag;
cmd.Parameters.Add(f);
conn.Open();
int status = cmd.ExecuteNonQuery();
conn.Close();
return(status);
}
public int InsertFAQ(faqs faq)
{
lock (locker)
{
if (faq.id != 0)
{
database.Update(faq);
return(faq.id);
}
else
{
return(database.Insert(faq));
}
}
}
public async Task GetFAQssync()
{
App.Database.limpiarFAQs();
Uri uri = new Uri(Constantes.URL_Users_allQuestion);
FAQs = new List <FAQsRespuesta>();
try
{
System.Diagnostics.Debug.WriteLine("PARAMETROS: " + uri);
var respuesta = await cliente.GetStringAsync(uri);
System.Diagnostics.Debug.WriteLine("RESPUESTA: " + respuesta);
FAQs = JsonConvert.DeserializeObject <List <FAQsRespuesta> >(respuesta);
foreach (var preguntaFrecuente in FAQs)
{
faqs faq = new faqs
{
pregunta = preguntaFrecuente.pregunta,
respuesta = preguntaFrecuente.respuesta
};
try
{
await Task.Run(() =>
{
if (App.database.InsertFAQ(faq) == 1)
{
System.Diagnostics.Debug.WriteLine("CORRECTO RECETAS: ¡Se ha realizado correctamente la insersion de datos!");
}
else
{
System.Diagnostics.Debug.WriteLine("ERROR: ¡Ha ocurrido un error inesperado al insercion de datos!");
}
});
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine("ERROR: " + e.Message);
}
}
}
catch (Exception e)
{
Debug.WriteLine("ERROR: " + e.Message);
}
}
public DataTable faqsdetails(faqs f)
{
DataTable dt = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
StringBuilder str = new StringBuilder();
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "faqsdetails....");
str.Append("Question:" + f.Question + ",");
str.Append("Answer:" + f.Answer + ",");
str.Append("Catid:" + f.Catid + ",");
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Input sent...." + str.ToString());
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PSInsUpdFaqs";
cmd.Connection = conn;
SqlParameter q = new SqlParameter("@Id", SqlDbType.Int);
q.Value = f.Id;
cmd.Parameters.Add(q);
SqlParameter q1 = new SqlParameter("@Question", SqlDbType.VarChar, 500);
q1.Value = f.Question;
cmd.Parameters.Add(q1);
SqlParameter e = new SqlParameter("@Answer", SqlDbType.VarChar, 500);
e.Value = f.Answer;
cmd.Parameters.Add(e);
SqlParameter t = new SqlParameter("@Catid", SqlDbType.Int);
t.Value = f.Catid;
cmd.Parameters.Add(t);
SqlParameter c = new SqlParameter("@CreatedOn", SqlDbType.Date);
c.Value = f.CreatedOn;
cmd.Parameters.Add(c);
SqlParameter b = new SqlParameter("@Createdby", SqlDbType.Int);
b.Value = f.Createdby;
cmd.Parameters.Add(b);
SqlParameter f1 = new SqlParameter("@flag", SqlDbType.VarChar);
f1.Value = f.flag;
cmd.Parameters.Add(f1);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "faqsdetails successful....");
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "faqsdetails...." + ex.Message.ToString());
//throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
dt.Columns.Add("Code");
dt.Columns.Add("description");
DataRow dr = dt.NewRow();
dr[0] = "ERR001";
dr[1] = ex.Message;
dt.Rows.Add(dr);
}
finally
{
conn.Close();
conn.Dispose();
SqlConnection.ClearPool(conn);
}
return(dt);
//Verify Passwordotp
}
