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("", "")));
}
