//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);
}
//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);
}
//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;
}
//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);
}
//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;
}
//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;
}