public bool ThemDuLieu(DungSaiNCC dungSaiNCC) { string[] names = new string[] { "@id", "@mancc", "@nhomvt", "@subquery" }; object[] values = new object[] { dungSaiNCC.ID, dungSaiNCC.MaNCC, dungSaiNCC.NhomVT, dungSaiNCC.SubQuery }; string query = "INSERT INTO DungSaiNCC(ID, MaNCC, NhomVT, SubQuery) VALUES(@id, @mancc, @nhomvt, @subquery)"; return(_sQLiteProvider.ExecuteNonQuery(query, names, values)); }
public int InsertDungSai(string maNCC, string nhomVT, string subQuery) { DungSaiNCC dungSaiNCC = new DungSaiNCC(); dungSaiNCC.MaNCC = maNCC; dungSaiNCC.NhomVT = nhomVT; dungSaiNCC.SubQuery = subQuery; return(_dungSaiNCCDAL.InsertDungSai(dungSaiNCC)); }
public int InsertDungSai(DungSaiNCC dungSaiNCC) { string[] names = new string[] { "@mancc", "@nhomvt", "@subquery" }; object[] values = new object[] { dungSaiNCC.MaNCC, dungSaiNCC.NhomVT, dungSaiNCC.SubQuery }; string[] namesOut = new string[] { "@id" }; object[] valuesOut = new object[] { SqlDbType.Int }; _provider.ExecuteNonQuery("Proc_InsertDungSai", names, values, namesOut, ref valuesOut); return(!string.IsNullOrEmpty(valuesOut[0].ToString()) ? (int)valuesOut[0] : 0); }
public bool UpdateDungSai(int id, string maNCC, string nhomVT, string subQuery) { DungSaiNCC dungSaiNCC = new DungSaiNCC(); dungSaiNCC.ID = id; dungSaiNCC.MaNCC = maNCC; dungSaiNCC.NhomVT = nhomVT; dungSaiNCC.SubQuery = subQuery; return(_dungSaiNCCDAL.UpdateDungSai(dungSaiNCC)); }
public bool UpdateDungSai(DungSaiNCC dungSaiNCC) { string[] names = new string[] { "@id", "@mancc", "@nhomvt", "@subquery" }; object[] values = new object[] { dungSaiNCC.ID, dungSaiNCC.MaNCC, dungSaiNCC.NhomVT, dungSaiNCC.SubQuery }; return(_provider.ExecuteNonQuery("Proc_UpdateDungSai", names, values)); }