//public static void CreateTables() //{ // using (var cmd = new SQLiteCommand(con)) // { // cmd.CommandText = @SQL_CREATE_USERS; // cmd.ExecuteNonQuery(); // cmd.CommandText = @SQL_CREATE_VILLAGES; // cmd.ExecuteNonQuery(); // cmd.CommandText = @SQL_DELETE_ZSTANDARDS; // cmd.ExecuteNonQuery(); // //cmd.CommandText = @SQL_DELETE_FORMS; // //cmd.ExecuteNonQuery(); // }; // con.Close(); //} //public static void InsertTestUser(List<users> users) //{ // using (con) // { // con.Open(); // using (var cmd = con.CreateCommand()) // { // cmd.CommandText = "INSERT INTO users (username, password) VALUES(@username, @password)"; // for (int i = 0; i < users.Count; i++) // { // cmd.Parameters.Clear(); // cmd.Parameters.AddWithValue("@username", users[i].username); // cmd.Parameters.AddWithValue("@password", users[i].password); // cmd.ExecuteNonQuery(); // } // } // con.Close(); // } //} public void InsertForm(forms_data form_data) { var rdnum = new System.Random(); string ml = DateTime.Now.ToString("mmss"); int random = rdnum.Next(100); string abc = ml + random; string def = abc.Substring(1, 3); int id = Convert.ToInt16(def); using (con) { try { con.Open(); using (var cmd = con.CreateCommand()) { cmd.CommandText = "INSERT INTO forms (_id,f1,f2,f3,f4,f5,f6,f7) VALUES (@_id,@f1,@f2,@f3,@f4,@f5,@f6,@f7)"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("_id", id); cmd.Parameters.AddWithValue("f1", form_data.f1); cmd.Parameters.AddWithValue("f2", form_data.f2); cmd.Parameters.AddWithValue("f3", form_data.f3); cmd.Parameters.AddWithValue("f4", form_data.f4); cmd.Parameters.AddWithValue("f5", form_data.f5); cmd.Parameters.AddWithValue("f6", form_data.f6); cmd.Parameters.AddWithValue("f7", form_data.f7); //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); } } }
public List <forms_data> UploadForms() { List <forms_data> froms = new List <forms_data>(); try { con.Open(); using (var cmd = con.CreateCommand()) { cmd.CommandText = "select * from forms where synced is Null"; r = cmd.ExecuteReader(); while (r.Read()) { forms_data f = new forms_data(); f._id = r["_id"].ToString(); f._uid = r["_uid"].ToString(); f.appversion = r["appversion"].ToString(); f.f1 = r["f1"].ToString(); f.f2 = r["f2"].ToString(); f.f3 = r["f3"].ToString(); f.f4 = r["f4"].ToString(); f.f5 = r["f5"].ToString(); f.f6 = r["f6"].ToString(); f.f7 = r["f7"].ToString(); f.deviceid = r["deviceid"].ToString(); f.endingdatetime = r["endingdatetime"].ToString(); f.gpsacc = r["gpsacc"].ToString(); f.gpsdate = r["gpsdate"].ToString(); f.gpslat = r["gpslat"].ToString(); f.gpslng = r["gpslng"].ToString(); f.istatus = r["istatus"].ToString(); f.istatus96x = r["istatus96x"].ToString(); f.sysdate = r["sysdate"].ToString(); f.tagid = r["tagid"].ToString(); f.username = r["username"].ToString(); // froms.Add(f); } r.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } return(froms); }
public void Insert_Form() { control_value(); forms_data fr = new forms_data(); fr.f1 = f1; fr.f2 = f2; fr.f3 = dateTime_dob.Value.ToString("MM/dd/yyyy"); fr.f4 = f4; fr.f5 = f5; fr.f6 = f6; fr.f7 = f7; db.InsertForm(fr); }
public List <forms_data> GetForms() { List <forms_data> froms = new List <forms_data>(); try { con.Open(); using (var cmd = con.CreateCommand()) { cmd.CommandText = "select * from forms "; r = cmd.ExecuteReader(); while (r.Read()) { forms_data f = new forms_data(); f.f1 = r["f1"].ToString(); f.f2 = r["f2"].ToString(); f.f3 = r["f3"].ToString(); f.f4 = r["f4"].ToString(); f.f5 = r["f5"].ToString(); f.f6 = r["f6"].ToString(); f.f7 = r["f7"].ToString(); // froms.Add(f); } r.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } return(froms); }
public List <forms_data> fetchData() { CConnection cn = new CConnection(); List <forms_data> forms = new List <forms_data>(); try { SQLiteDataAdapter da = new SQLiteDataAdapter("select * from camp_patient_dtl where synced is null or synced = ''", cn.cn); DataSet ds = new DataSet(); da.Fill(ds); for (int a = 0; a <= ds.Tables[0].Rows.Count - 1; a++) { forms_data fd = new forms_data(); fd._id = ds.Tables[0].Rows[a]["id"].ToString(); fd.deviceid = SystemInformation.ComputerName; fd.sysdate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); fd.id = ds.Tables[0].Rows[a]["id"].ToString(); fd.form_id = ds.Tables[0].Rows[a]["form_id"].ToString(); fd.mh01 = ds.Tables[0].Rows[a]["mh01"].ToString(); fd.mh02 = ds.Tables[0].Rows[a]["mh02"].ToString(); fd.mh03 = ds.Tables[0].Rows[a]["mh03"].ToString(); fd.mh04 = ds.Tables[0].Rows[a]["mh04"].ToString(); fd.mh05 = ds.Tables[0].Rows[a]["mh05"].ToString(); fd.mh06 = ds.Tables[0].Rows[a]["mh06"].ToString(); fd.mh07 = ds.Tables[0].Rows[a]["mh07"].ToString(); fd.mh08 = ds.Tables[0].Rows[a]["mh08"].ToString(); fd.mh09y = ds.Tables[0].Rows[a]["mh09y"].ToString(); fd.mh09m = ds.Tables[0].Rows[a]["mh09m"].ToString(); fd.mh09d = ds.Tables[0].Rows[a]["mh09d"].ToString(); fd.mh010 = ds.Tables[0].Rows[a]["mh010"].ToString(); fd.mh010a = ds.Tables[0].Rows[a]["mh010a"].ToString(); fd.mh01101 = ds.Tables[0].Rows[a]["mh01101"].ToString(); fd.mh01102 = ds.Tables[0].Rows[a]["mh01102"].ToString(); fd.mh01103 = ds.Tables[0].Rows[a]["mh01103"].ToString(); fd.mh012 = ds.Tables[0].Rows[a]["mh012"].ToString(); fd.chkWeight = ds.Tables[0].Rows[a]["chkWeight"].ToString(); fd.mh013 = ds.Tables[0].Rows[a]["mh013"].ToString(); fd.mh014 = ds.Tables[0].Rows[a]["mh014"].ToString(); fd.mh015 = ds.Tables[0].Rows[a]["mh015"].ToString(); fd.chkHeight = ds.Tables[0].Rows[a]["chkHeight"].ToString(); fd.mh016 = ds.Tables[0].Rows[a]["mh016"].ToString(); fd.chkMUAC = ds.Tables[0].Rows[a]["chkMUAC"].ToString(); fd.mh011 = ds.Tables[0].Rows[a]["mh011"].ToString(); fd.mh01701 = ds.Tables[0].Rows[a]["mh01701"].ToString(); fd.mh01702 = ds.Tables[0].Rows[a]["mh01702"].ToString(); fd.mh01703 = ds.Tables[0].Rows[a]["mh01703"].ToString(); fd.mh01704 = ds.Tables[0].Rows[a]["mh01704"].ToString(); fd.mh01705 = ds.Tables[0].Rows[a]["mh01705"].ToString(); fd.mh017077 = ds.Tables[0].Rows[a]["mh017077"].ToString(); fd.mh017077x = ds.Tables[0].Rows[a]["mh017077x"].ToString(); fd.mh01801 = ds.Tables[0].Rows[a]["mh01801"].ToString(); fd.mh01802 = ds.Tables[0].Rows[a]["mh01802"].ToString(); fd.mh01803 = ds.Tables[0].Rows[a]["mh01803"].ToString(); fd.mh01804 = ds.Tables[0].Rows[a]["mh01804"].ToString(); fd.mh01805 = ds.Tables[0].Rows[a]["mh01805"].ToString(); fd.mh01806 = ds.Tables[0].Rows[a]["mh01806"].ToString(); fd.mh01807 = ds.Tables[0].Rows[a]["mh01807"].ToString(); fd.mh01808 = ds.Tables[0].Rows[a]["mh01808"].ToString(); fd.mh01809 = ds.Tables[0].Rows[a]["mh01809"].ToString(); fd.mh018010 = ds.Tables[0].Rows[a]["mh018010"].ToString(); fd.mh018011 = ds.Tables[0].Rows[a]["mh018011"].ToString(); fd.mh018012 = ds.Tables[0].Rows[a]["mh018012"].ToString(); fd.mh018013 = ds.Tables[0].Rows[a]["mh018013"].ToString(); fd.mh018014 = ds.Tables[0].Rows[a]["mh018014"].ToString(); fd.mh018015 = ds.Tables[0].Rows[a]["mh018015"].ToString(); fd.mh018016 = ds.Tables[0].Rows[a]["mh018016"].ToString(); fd.mh018077 = ds.Tables[0].Rows[a]["mh018077"].ToString(); fd.mh018077x = ds.Tables[0].Rows[a]["mh018077x"].ToString(); fd.chkNoneDiag = ds.Tables[0].Rows[a]["chkNoneDiag"].ToString(); fd.mh01901 = ds.Tables[0].Rows[a]["mh01901"].ToString(); fd.mh01902 = ds.Tables[0].Rows[a]["mh01902"].ToString(); fd.mh01903 = ds.Tables[0].Rows[a]["mh01903"].ToString(); fd.mh01904 = ds.Tables[0].Rows[a]["mh01904"].ToString(); fd.mh01905 = ds.Tables[0].Rows[a]["mh01905"].ToString(); fd.mh01906 = ds.Tables[0].Rows[a]["mh01906"].ToString(); fd.mh01907 = ds.Tables[0].Rows[a]["mh01907"].ToString(); fd.mh01908 = ds.Tables[0].Rows[a]["mh01908"].ToString(); fd.mh01909 = ds.Tables[0].Rows[a]["mh01909"].ToString(); fd.mh019010 = ds.Tables[0].Rows[a]["mh019010"].ToString(); fd.mh019011 = ds.Tables[0].Rows[a]["mh019011"].ToString(); fd.mh019012 = ds.Tables[0].Rows[a]["mh019012"].ToString(); fd.mh019013 = ds.Tables[0].Rows[a]["mh019013"].ToString(); fd.mh019014 = ds.Tables[0].Rows[a]["mh019014"].ToString(); fd.mh019015 = ds.Tables[0].Rows[a]["mh019015"].ToString(); fd.mh019017 = ds.Tables[0].Rows[a]["mh019017"].ToString(); fd.mh019077 = ds.Tables[0].Rows[a]["mh019077"].ToString(); fd.mh019077x = ds.Tables[0].Rows[a]["mh019077x"].ToString(); fd.chkNone = ds.Tables[0].Rows[a]["chkNone"].ToString(); fd.mh020 = ds.Tables[0].Rows[a]["mh020"].ToString(); fd.mh021 = ds.Tables[0].Rows[a]["mh021"].ToString(); fd.mh021a = ds.Tables[0].Rows[a]["mh021a"].ToString(); fd.mh021TTDose = ds.Tables[0].Rows[a]["mh021TTDose"].ToString(); fd.mh022 = ds.Tables[0].Rows[a]["mh022"].ToString(); fd.mh023 = ds.Tables[0].Rows[a]["mh023"].ToString(); fd.mh024 = ds.Tables[0].Rows[a]["mh024"].ToString(); fd.mh025 = ds.Tables[0].Rows[a]["mh025"].ToString(); fd.mh032 = ds.Tables[0].Rows[a]["mh032"].ToString(); fd.mh030 = ds.Tables[0].Rows[a]["mh030"].ToString(); fd.mh033 = ds.Tables[0].Rows[a]["mh033"].ToString(); fd.mh031 = ds.Tables[0].Rows[a]["mh031"].ToString(); fd.mh02601 = ds.Tables[0].Rows[a]["mh02601"].ToString(); fd.mh02602 = ds.Tables[0].Rows[a]["mh02602"].ToString(); fd.mh02603 = ds.Tables[0].Rows[a]["mh02603"].ToString(); fd.mh02604 = ds.Tables[0].Rows[a]["mh02604"].ToString(); fd.mh02605 = ds.Tables[0].Rows[a]["mh02605"].ToString(); fd.mh02606 = ds.Tables[0].Rows[a]["mh02606"].ToString(); fd.mh027a = ds.Tables[0].Rows[a]["mh027a"].ToString(); fd.mh02607 = ds.Tables[0].Rows[a]["mh02607"].ToString(); fd.mh02608 = ds.Tables[0].Rows[a]["mh02608"].ToString(); fd.mh02609 = ds.Tables[0].Rows[a]["mh02609"].ToString(); fd.mh026010 = ds.Tables[0].Rows[a]["mh026010"].ToString(); fd.mh026011 = ds.Tables[0].Rows[a]["mh026011"].ToString(); fd.mh027b = ds.Tables[0].Rows[a]["mh027b"].ToString(); fd.mh026012 = ds.Tables[0].Rows[a]["mh026012"].ToString(); fd.mh026013 = ds.Tables[0].Rows[a]["mh026013"].ToString(); fd.mh026014 = ds.Tables[0].Rows[a]["mh026014"].ToString(); fd.mh026015 = ds.Tables[0].Rows[a]["mh026015"].ToString(); fd.mh026016 = ds.Tables[0].Rows[a]["mh026016"].ToString(); fd.mh026017 = ds.Tables[0].Rows[a]["mh026017"].ToString(); fd.mh026018 = ds.Tables[0].Rows[a]["mh026018"].ToString(); fd.mh026019 = ds.Tables[0].Rows[a]["mh026019"].ToString(); fd.mh026Sup = ds.Tables[0].Rows[a]["mh026Sup"].ToString(); fd.chkVaccination = ds.Tables[0].Rows[a]["chkVaccination"].ToString(); fd.mh027 = ds.Tables[0].Rows[a]["mh027"].ToString(); fd.mh028 = ds.Tables[0].Rows[a]["mh028"].ToString(); fd.mh029 = ds.Tables[0].Rows[a]["mh029"].ToString(); fd.uccode = ds.Tables[0].Rows[a]["uccode"].ToString(); fd.dist_id = ds.Tables[0].Rows[a]["dist_id"].ToString(); fd.databy = "desktop"; fd.userid = ds.Tables[0].Rows[a]["userid"].ToString(); fd.entrydate = ds.Tables[0].Rows[a]["entrydate"].ToString(); fd.master_id = ds.Tables[0].Rows[a]["master_id"].ToString(); fd.ver = ds.Tables[0].Rows[a]["ver"].ToString(); forms.Add(fd); } } catch (Exception ex) { } finally { } return(forms); }