public void Add(string name, string price, string items, string State, string id) { SQLiteConnection cn = new SQLiteConnection(); cn.ConnectionString = D.ConnectionString(name, password); string IQUERY = "INSERT INTO MEGA(NAME,STATE,ITEMS,PRICE,ID) VALUES('" + name + "','" + price + "','" + items + "','" + State + "','" + id + "')"; SQLiteCommand com = new SQLiteCommand(); com.CommandText = IQUERY; com.Connection = cn; cn.Open(); com.ExecuteNonQuery(); cn.Close(); }
public void Show(DataTable datatable) { SQLiteConnection cn = new SQLiteConnection(); cn.ConnectionString = D.ConnectionString(name, pass); cn.Open(); String IQuery = "Select * From ACCOUNT"; System.Data.SQLite.SQLiteCommand cm = new System.Data.SQLite.SQLiteCommand(); cm.CommandText = IQuery; cm.Connection = cn; SQLiteDataAdapter IODA = new SQLiteDataAdapter(cm); IODA.Fill(datatable); cn.Close(); }
/// public void add1(string id, string name, string price, string date, string darec, string conprou, string typeprou, string discounts, int isdone) { var d = new Assest.OrcDataAcess(); SQLiteConnection cna = new SQLiteConnection(); cna.ConnectionString = d.ConnectionString("", ""); string insert_query = null; insert_query = "INSERT INTO MEGARIP2 (NAME,PRICE,DAT,discounts,datrec,conprou,typeprou,isdone,ID) VALUES ('" + name + "','" + price + "','" + date + "','" + discounts + "','" + darec + "','" + conprou + "','" + typeprou + "','" + isdone + "','" + id.ToString().Replace("-", "") + "')"; // string insert_query = "INSERT INTO MEGARIP ([ID],[NAME],[PRICE],[DAT],[discounts],[datrec],[conprou],[typeprou],[isdone]) VALUES(?,?,?,?,?,?,?,?,?)"; // string insert = "INSERT INTO MEGARIP(ID,NAME,PRICE,DAT,discounts,datrec,conprou,typeprou,isdone) VALUES('"+"g"+"','"+"A"+"','"+"123"+"','"+"ABC"+"','"+"HG"+"','"+"ABC"+"','"+"as"+"','"+"HGT"+"','"+Booolint+"')"; // String Ainsert="INSERT INTO MEGARIP(ID,NAME,PRICE,DAT,discounts,datrec)" System.Data.SQLite.SQLiteCommand cm = new System.Data.SQLite.SQLiteCommand(); cm.Connection = cna; // cm.CommandType = CommandType.Text; cm.CommandText = insert_query; //cm.Parameters.AddWithValue("?", id);//1 //cm.Parameters.AddWithValue("?", name);//2 //cm.Parameters.AddWithValue("?", price);//3 //cm.Parameters.AddWithValue("?", date);//4 //cm.Parameters.AddWithValue("?", discounts);//5 //cm.Parameters.AddWithValue("?", "FG");//6 //cm.Parameters.AddWithValue("?", conprou);//7 //cm.Parameters.AddWithValue("?", typeprou);//8 //cm.Parameters.AddWithValue("?", isdone);//9 cna.Open(); cm.ExecuteNonQuery(); cna.Close(); }
public void Delete(String index) { var d = new Assest.OrcDataAcess(); SQLiteConnection cn = new SQLiteConnection(); cn.ConnectionString = d.ConnectionString("", ""); string insert_query = $"DELETE from [MEGARIP] WHERE ID ='{index}'"; System.Data.SQLite.SQLiteCommand cm = new System.Data.SQLite.SQLiteCommand(insert_query, cn); cn.Open(); cm.ExecuteNonQuery(); cn.Close(); }
/// </summary> public void Delete1() { var d = new Assest.OrcDataAcess(); SQLiteConnection cn = new SQLiteConnection(); cn.ConnectionString = d.ConnectionString("", ""); string insert_query = "DELETE from [MEGARIP2]"; System.Data.SQLite.SQLiteCommand cm = new System.Data.SQLite.SQLiteCommand(insert_query, cn); // cm.Parameters.AddWithValue("?", index); cn.Open(); cm.ExecuteNonQuery(); cn.Close(); }
public void Edit1(string id, string name, string price, string date, string darec, string conprou, string typeprou, string discounts, int isdone) { //ID,NAME,PRICE,DAT,discounts,datrec,conprou,typeprou,isdone SQLiteConnection cn = new SQLiteConnection(); var d = new Assest.OrcDataAcess(); cn.ConnectionString = d.ConnectionString("", ""); string insert_query = $"UPDATE MEGARIP2 SET NAME='{name}',PRICE='{price}' ,DAT='{date}' ,discounts='{discounts}' ,datrec='{darec}' ,conprou='{conprou}' ,typeprou='{typeprou}',isdone='{isdone}' WHERE ID ='{id}'"; System.Data.SQLite.SQLiteCommand cm = new System.Data.SQLite.SQLiteCommand(); cm.Connection = cn; cm.CommandText = insert_query; cn.Open(); cm.ExecuteNonQuery(); cn.Close(); }
/* * في نظام الاضافة لقسم الصيانة نحتاج الى * ----------------------------------------------- * اسم الصنف //name * ------------------------------------------ * ترميز الصنف //id * ---------------------------------------------- * تاريخ اضافة الصنف //date * ---------------------------------------------- * * موعد استلام الصنف //darec * --------------------------------------------- * --------------------- * نسبة الخصم.. //discounts * ---------------------------------------------- * وصف العطل في الصنف conprou * -------------------------------------------------- * لمعرفة هل الطلب تم تسليمه ام لا isdone? * -------------------------------------------------------- * نوع الصنف typeprou * ----- -------------------------------------------------------- *//// <summary> /// Erd Sys /// public void add(string id, string name, string price, string date, string darec, string conprou, string typeprou, string discounts, int isdone) { var d = new Assest.OrcDataAcess(); SQLiteConnection cna = new SQLiteConnection(); cna.ConnectionString = d.ConnectionString("", ""); string insert_query = null; insert_query = "INSERT INTO MEGARIP (NAME,PRICE,DAT,discounts,datrec,conprou,typeprou,isdone,ID) VALUES ('" + name + "','" + price + "','" + date + "','" + discounts + "','" + darec + "','" + conprou + "','" + typeprou + "','" + isdone + "','" + id.ToString().Replace("-", "") + "')"; System.Data.SQLite.SQLiteCommand cm = new System.Data.SQLite.SQLiteCommand(); cm.Connection = cna; // cm.CommandType = CommandType.Text; cm.CommandText = insert_query; cna.Open(); cm.ExecuteNonQuery(); cna.Close(); }
public SQLiteConnection cn() { var a = new Assest.OrcDataAcess(); return(new SQLiteConnection(a.ConnectionString("", ""))); }