/// <summary>
/// Inserts the data.
/// </summary>
/// <param name="dataId">The data id.</param>
/// <param name="fieldId">The field id.</param>
/// <param name="pageId">The page id.</param>
/// <param name="inputType">Type of the input.</param>
/// <param name="sValue">The s value.</param>
/// <param name="bValue">The b value.</param>
/// <param name="dValue">The d value.</param>
public static void InsertData(int dataId, int fieldId, int pageId, string inputType, string sValue, bool?bValue, DateTime?dValue)
{
string conn = ConnectionManager();
LotusDataContext db = new LotusDataContext(conn);
form_data data = new form_data();
data.form_data_id = dataId;
data.form_field_definition_id = fieldId;
data.page_id = pageId;
switch (inputType)
{
case "txtBox":
case "ddList":
case "radioBtnList":
case "timePicker":
data.value1 = sValue;
break;
case "txtArea":
case "chkBoxList":
case "addressCtrl":
data.value2 = sValue;
break;
case "chkBox":
data.value3 = bValue;
break;
case "datePicker":
data.value6 = dValue;
break;
}
db.form_datas.InsertOnSubmit(data);
db.SubmitChanges();
}
public void Insert()
{
controls_value();
DateTime now = DateTime.Now;
form_data forms = new form_data();
forms.cr01 = DataBaseVariable.dis1;
forms.cr02 = DataBaseVariable.CR_02;
forms.cr03 = DataBaseVariable.CR_03;
forms.cr04 = DataBaseVariable.ucss1;
forms.cr05 = DataBaseVariable.vill1;
forms.cr06 = DataBaseVariable.CR_06;
forms.cr07 = DataBaseVariable.CR_07;
forms.cr08d = DataBaseVariable.ScreenData.ToString("dd");
forms.cr08m = DataBaseVariable.ScreenData.ToString("MM");
forms.cr08y = DataBaseVariable.ScreenData.ToString("yyyy");
forms.cr09 = DataBaseVariable.CR_09;
forms.cr10 = cr10;
forms.cr11 = cr11;
forms.cr12 = cr12;
forms.cr13 = cr13;
forms.cr14d = cr10;
forms.cr15m = cr10;
forms.cr15y = cr10;
forms.cr16 = cr16;
forms.cr21 = cr21;
forms.cr22 = cr22;
forms.cr23 = cr23;
forms.cr17 = cr17;
forms.cr18 = cr18;
forms.cr19 = cr19;
forms.cr20 = cr20;
forms.cr24a = cr24a;
forms.cr24b = cr24b;
forms.cr24c = cr24c;
forms.cr24d = cr24d;
forms.cr24e = cr24e;
forms.cr24f = cr24f;
forms.cr25 = cr25;
forms.cr26 = cr26;
forms.cr27a = cr27a;
forms.cr27b = cr27b;
forms.cr27c = cr27c;
forms.cr28a = cr28a;
forms.cr28b = cr28b;
forms.cr28c = cr28c;
forms.cr28d = cr28d;
forms.cr28e = cr28e;
forms.cr28f = cr28fx;
forms.cr28fx = cr28fx;
forms.endingdatetime = now.ToString("MM/dd/yyyy HH:mm:ss.fff");
forms.username = DataBaseVariable.UserName;
SQLiteDatabase.InsertForm(forms);
////ShowStatus(result, "Save");
}
public List <form_data> GetAllForms()
{
List <form_data> fdList = new List <form_data>();
con.Open();
using (var cmd = con.CreateCommand())
{
cmd.CommandText = @"SELECT * from forms";
SqliteDataReader r = cmd.ExecuteReader();
while (r.Read())
{
form_data fd = new form_data();
fd._id = r["_id"].ToString();
fd._uid = r["_uid"].ToString();
fd.appversion = r["appversion"].ToString();
fd.cr01 = r["cr01"].ToString();
fd.cr02 = r["cr02"].ToString();
fd.cr03 = r["cr03"].ToString();
fd.cr04 = r["cr04"].ToString();
fd.cr05 = r["cr05"].ToString();
fd.cr06 = r["cr06"].ToString();
fd.cr07 = r["cr07"].ToString();
fd.cr08d = r["cr08d"].ToString();
fd.cr08m = r["cr08m"].ToString();
fd.cr08y = r["cr08y"].ToString();
fd.cr09 = r["cr09"].ToString();
fd.cr10 = r["cr10"].ToString();
fd.cr11 = r["cr11"].ToString();
fd.cr12 = r["cr12"].ToString();
fd.cr13 = r["cr13"].ToString();
fd.cr14d = r["cr14d"].ToString();
fd.cr15m = r["cr15m"].ToString();
fd.cr15y = r["cr15y"].ToString();
fd.cr16 = r["cr16"].ToString();
fd.cr17 = r["cr17"].ToString();
fd.cr18 = r["cr18"].ToString();
fd.cr19 = r["cr19"].ToString();
fd.cr20 = r["cr20"].ToString();
fd.cr21 = r["cr21"].ToString();
fd.cr22 = r["cr22"].ToString();
fd.cr23 = r["cr23"].ToString();
fd.cr24a = r["cr24a"].ToString();
fd.cr24b = r["cr24b"].ToString();
fd.cr24c = r["cr24c"].ToString();
fd.cr24d = r["cr24d"].ToString();
fd.cr24e = r["cr24e"].ToString();
fd.cr24f = r["cr24f"].ToString();
fd.cr25 = r["cr25"].ToString();
fd.cr26 = r["cr26"].ToString();
fd.cr27a = r["cr27a"].ToString();
fd.cr27b = r["cr27b"].ToString();
fd.cr27c = r["cr27c"].ToString();
fd.cr28a = r["cr28a"].ToString();
fd.cr28b = r["cr28b"].ToString();
fd.cr28c = r["cr28c"].ToString();
fd.cr28d = r["cr28d"].ToString();
fd.cr28e = r["cr28e"].ToString();
fd.cr28f = r["cr28f"].ToString();
fd.cr28fx = r["cr28fx"].ToString();
fd.deviceid = r["deviceid"].ToString();
fd.endingdatetime = r["endingdatetime"].ToString();
fd.gpsacc = r["gpsacc"].ToString();
fd.gpsdate = r["gpsdate"].ToString();
fd.gpslat = r["gpslat"].ToString();
fd.gpslng = r["gpslng"].ToString();
fd.istatus = r["istatus"].ToString();
fd.istatus96x = r["istatus96x"].ToString();
fd.sysdate = r["sysdate"].ToString();
fd.tagid = r["tagid"].ToString();
fd.username = r["username"].ToString();
//
fdList.Add(fd);
}
}
con.Close();
return(fdList);
}
public static void InsertForm(form_data forms_data)
{
using (con)
{
try
{
con.Open();
using (var cmd = con.CreateCommand())
{
cmd.CommandText = "INSERT INTO forms (cr01,cr02,cr03,cr04,cr05,cr06,cr07,cr08d,cr08m,cr08y,cr09,cr10,cr11,cr12,cr13,cr14d,cr15m,cr15y,cr16,cr17,cr18,cr19,cr20,cr21,cr22,cr23,cr24a,cr24b,cr24c,cr24d,cr24e,cr24f,cr25,cr26,cr27a,cr27b,cr27c,cr28a,cr28b,cr28c,cr28d,cr28e,cr28f,cr28fx,endingdatetime,username) VALUES (@cr01,@cr02,@cr03,@cr04,@cr05,@cr06,@cr07,@cr08d,@cr08m,@cr08y,@cr09,@cr10,@cr11,@cr12,@cr13,@cr14d,@cr15m,@cr15y,@cr16,@cr17,@cr18,@cr19,@cr20,@cr21,@cr22,@cr23,@cr24a,@cr24b,@cr24c,@cr24d,@cr24e,@cr24f,@cr25,@cr26,@cr27a,@cr27b,@cr27c,@cr28a,@cr28b,@cr28c,@cr28d,@cr28e,@cr28f,@cr28fx,@endingdatetime,@username)";
//for (int i = 0; i < forms_data.Count; i++)
//{
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("cr01", forms_data.cr01);
cmd.Parameters.AddWithValue("cr02", forms_data.cr02);
cmd.Parameters.AddWithValue("cr03", forms_data.cr03);
cmd.Parameters.AddWithValue("cr04", forms_data.cr04);
cmd.Parameters.AddWithValue("cr05", forms_data.cr05);
cmd.Parameters.AddWithValue("cr06", forms_data.cr06);
cmd.Parameters.AddWithValue("cr07", forms_data.cr07);
cmd.Parameters.AddWithValue("cr08d", forms_data.cr08d);
cmd.Parameters.AddWithValue("cr08m", forms_data.cr08m);
cmd.Parameters.AddWithValue("cr08y", forms_data.cr08y);
cmd.Parameters.AddWithValue("cr09", forms_data.cr09);
cmd.Parameters.AddWithValue("cr10", forms_data.cr10);
cmd.Parameters.AddWithValue("cr11", forms_data.cr11);
cmd.Parameters.AddWithValue("cr12", forms_data.cr12);
cmd.Parameters.AddWithValue("cr13", forms_data.cr13);
cmd.Parameters.AddWithValue("cr14d", forms_data.cr14d);
cmd.Parameters.AddWithValue("cr15m", forms_data.cr15m);
cmd.Parameters.AddWithValue("cr15y", forms_data.cr15y);
cmd.Parameters.AddWithValue("cr16", forms_data.cr16);
cmd.Parameters.AddWithValue("cr17", forms_data.cr17);
cmd.Parameters.AddWithValue("cr18", forms_data.cr18);
cmd.Parameters.AddWithValue("cr19", forms_data.cr19);
cmd.Parameters.AddWithValue("cr20", forms_data.cr20);
cmd.Parameters.AddWithValue("cr21", forms_data.cr21);
cmd.Parameters.AddWithValue("cr22", forms_data.cr22);
cmd.Parameters.AddWithValue("cr23", forms_data.cr23);
cmd.Parameters.AddWithValue("cr24a", forms_data.cr24a);
cmd.Parameters.AddWithValue("cr24b", forms_data.cr24b);
cmd.Parameters.AddWithValue("cr24c", forms_data.cr24c);
cmd.Parameters.AddWithValue("cr24d", forms_data.cr24d);
cmd.Parameters.AddWithValue("cr24e", forms_data.cr24e);
cmd.Parameters.AddWithValue("cr24f", forms_data.cr24f);
cmd.Parameters.AddWithValue("cr25", forms_data.cr25);
cmd.Parameters.AddWithValue("cr26", forms_data.cr26);
cmd.Parameters.AddWithValue("cr27a", forms_data.cr27a);
cmd.Parameters.AddWithValue("cr27b", forms_data.cr27b);
cmd.Parameters.AddWithValue("cr27c", forms_data.cr27c);
cmd.Parameters.AddWithValue("cr28a", forms_data.cr28a);
cmd.Parameters.AddWithValue("cr28b", forms_data.cr28b);
cmd.Parameters.AddWithValue("cr28c", forms_data.cr28c);
cmd.Parameters.AddWithValue("cr28d", forms_data.cr28d);
cmd.Parameters.AddWithValue("cr28e", forms_data.cr28e);
cmd.Parameters.AddWithValue("cr28f", forms_data.cr28f);
cmd.Parameters.AddWithValue("cr28fx", forms_data.cr28fx);
//cmd.Parameters.AddWithValue("deviceid", forms_data.deviceid);
cmd.Parameters.AddWithValue("endingdatetime", forms_data.endingdatetime);
//cmd.Parameters.AddWithValue("gpsacc", forms_data.gpsacc);
//cmd.Parameters.AddWithValue("gpsdate", forms_data.gpsdate);
//cmd.Parameters.AddWithValue("gpslat", forms_data.gpslat);
//cmd.Parameters.AddWithValue("gpslng", forms_data.gpslng);
//cmd.Parameters.AddWithValue("istatus", forms_data.istatus);
//cmd.Parameters.AddWithValue("istatus96x", forms_data.istatus96x);
//cmd.Parameters.AddWithValue("sysdate", forms_data.sysdate);
//cmd.Parameters.AddWithValue("tagid", forms_data.tagid);
cmd.Parameters.AddWithValue("username", forms_data.username);
cmd.ExecuteNonQuery();
MessageBox.Show("SUCCESS!", "Form saved!");
//}
}
con.Close();
}
catch (Exception e)
{
MessageBox.Show("ERROR!", "Form was not saved. " + "\n" + e.Message);
}
}
}
