Esempio n. 1
0
 //Delete an Object in database dmQuanHuyen
 public static int Delete(dmQuanHuyen_Object DeletingObject)
 {
     List<SqlParameter> paralist = new List<SqlParameter>();
     string DeleteQuery =
     @"Delete [dmQuanHuyen]
     Where Id= @Id";
     paralist.Add(new SqlParameter("Id", DeletingObject.Id));
     return commonDatabase.ExecuteNonQuerySQL(clsConnectionString.GetConnectionString(), DeleteQuery, paralist);
 }
Esempio n. 2
0
 //Save changes of an Object to database dmQuanHuyen
 public static int SaveChanged(dmQuanHuyen_Object UpdatingObject)
 {
     List<SqlParameter> paralist = new List<SqlParameter>();
     string UpdateQuery =
     @"Update dmQuanHuyen SET
        TenQuanHuyen= @TenQuanHuyen,
        Id_TinhThanh= @Id_TinhThanh
     Where Id= @Id";
     paralist.Add(new SqlParameter("Id", UpdatingObject.Id));
     paralist.Add(new SqlParameter("TenQuanHuyen", UpdatingObject.TenQuanHuyen));
     paralist.Add(new SqlParameter("Id_TinhThanh", UpdatingObject.Id_TinhThanh));
     return commonDatabase.ExecuteNonQuerySQL(clsConnectionString.GetConnectionString(), UpdateQuery, paralist);
 }
Esempio n. 3
0
 //Get an Object of dmQuanHuyen
 public static dmQuanHuyen_Object GetObject(int _Id)
 {
     List<SqlParameter> paralist = new List<SqlParameter>();
     dmQuanHuyen_Object newObject = new dmQuanHuyen_Object();
     string SelectQuery = "Select * from [dmQuanHuyen] where (1=1) and [Id]= @Id";
     paralist.Add(new SqlParameter("Id", _Id));
     DataTable tb = commonDatabase.GetSQLDataTable(clsConnectionString.GetConnectionString(), SelectQuery, paralist);
     if (tb.Rows.Count < 1) return null;
     DataRow row = tb.Rows[0];
     newObject.Id = (int)row["Id"];
     if (row["TenQuanHuyen"].ToString() != "") newObject.TenQuanHuyen = (string)row["TenQuanHuyen"];
     if (row["Id_TinhThanh"].ToString() != "") newObject.Id_TinhThanh = (int)row["Id_TinhThanh"];
     return newObject;
 }
Esempio n. 4
0
 //Insert dmQuanHuyen
 public static int Insert(dmQuanHuyen_Object newObject)
 {
     string InsertQuery = "Insert Into [dmQuanHuyen]";
     List<SqlParameter> paralist = new List<SqlParameter>();
     string _val = "", _para = "";
     _val += "Id, "; _para += "@Id, ";
     paralist.Add(new SqlParameter("Id", newObject.Id));
     if (newObject.TenQuanHuyen != null)
     {
         _val += "TenQuanHuyen, "; _para += "@TenQuanHuyen, ";
         paralist.Add(new SqlParameter("TenQuanHuyen", newObject.TenQuanHuyen));
     }
     if (newObject.Id_TinhThanh != null)
     {
         _val += "Id_TinhThanh, "; _para += "@Id_TinhThanh, ";
         paralist.Add(new SqlParameter("Id_TinhThanh", newObject.Id_TinhThanh));
     }
     InsertQuery += "(" + _val + ") Values (" + _para + ")";
     InsertQuery = InsertQuery.Replace(", )", ")");
     return commonDatabase.ExecuteNonQuerySQL(clsConnectionString.GetConnectionString(), InsertQuery, paralist);
 }
Esempio n. 5
0
 //Select dmQuanHuyen y tinh tanh
 public static List<dmQuanHuyen_Object> SelectByIdTinhThanh(int _Id_TinhThanh)
 {
     string SelectQuery = "Select * from [dmQuanHuyen] where (1=1) and [Id_TinhThanh]= @Id_TinhThanh";
     List<SqlParameter> paralist = new List<SqlParameter>();
     paralist.Add(new SqlParameter("Id_TinhThanh", _Id_TinhThanh));
     List<dmQuanHuyen_Object> result = new List<dmQuanHuyen_Object>();
     DataTable tb = commonDatabase.GetSQLDataTable(clsConnectionString.GetConnectionString(), SelectQuery,paralist);
     foreach (DataRow row in tb.Rows)
     {
         dmQuanHuyen_Object newObject = new dmQuanHuyen_Object();
         newObject.Id = (int)row["Id"];
         if (row["TenQuanHuyen"].ToString() != "") newObject.TenQuanHuyen = (string)row["TenQuanHuyen"];
         if (row["Id_TinhThanh"].ToString() != "") newObject.Id_TinhThanh = (int)row["Id_TinhThanh"];
         result.Add(newObject);
     }
     return result;
 }
Esempio n. 6
0
 //Select dmQuanHuyen
 public static List<dmQuanHuyen_Object> SelectAll()
 {
     string SelectQuery = @"Select * from [dmQuanHuyen]";
     List<dmQuanHuyen_Object> result = new List<dmQuanHuyen_Object>();
     DataTable tb = commonDatabase.GetSQLDataTable(clsConnectionString.GetConnectionString(), SelectQuery);
     foreach (DataRow row in tb.Rows)
     {
         dmQuanHuyen_Object newObject = new dmQuanHuyen_Object();
         newObject.Id = (int)row["Id"];
         if (row["TenQuanHuyen"].ToString() != "") newObject.TenQuanHuyen = (string)row["TenQuanHuyen"];
         if (row["Id_TinhThanh"].ToString() != "") newObject.Id_TinhThanh = (int)row["Id_TinhThanh"];
         result.Add(newObject);
     }
     return result;
 }