//Delete an Object in database CongDan
public static int Delete(CongDan_Object DeletingObject)
{
List<SqlParameter> paralist = new List<SqlParameter>();
string DeleteQuery =
@"Delete [CongDan]
Where SoCMND= @SoCMND";
paralist.Add(new SqlParameter("SoCMND", DeletingObject.SoCMND));
return commonDatabase.ExecuteNonQuerySQL(clsConnectionString.GetConnectionString(), DeleteQuery, paralist);
}
//Get an Object of CongDan
public static CongDan_Object GetObject(string _SoCMND)
{
List<SqlParameter> paralist = new List<SqlParameter>();
CongDan_Object newObject = new CongDan_Object();
string SelectQuery = "Select * from [CongDan] where (1=1) and [SoCMND]= @SoCMND";
paralist.Add(new SqlParameter("SoCMND", _SoCMND));
DataTable tb = commonDatabase.GetSQLDataTable(clsConnectionString.GetConnectionString(), SelectQuery, paralist);
if (tb.Rows.Count < 1) return null;
DataRow row = tb.Rows[0];
if (row["HoTen"].ToString() != "") newObject.HoTen = (string)row["HoTen"];
if (row["NgaySinh"].ToString() != "") newObject.NgaySinh = (DateTime)row["NgaySinh"];
if (row["GioiTinh"].ToString() != "") newObject.GioiTinh = (string)row["GioiTinh"];
newObject.SoCMND = (string)row["SoCMND"];
if (row["SoHoChieu"].ToString() != "") newObject.SoHoChieu = (string)row["SoHoChieu"];
if (row["NgayCap"].ToString() != "") newObject.NgayCap = (DateTime)row["NgayCap"];
if (row["NoiCap"].ToString() != "") newObject.NoiCap = (string)row["NoiCap"];
if (row["Id_TinhThanh"].ToString() != "") newObject.Id_TinhThanh = (int)row["Id_TinhThanh"];
if (row["Id_QuanHuyen"].ToString() != "") newObject.Id_QuanHuyen = (int)row["Id_QuanHuyen"];
if (row["PhuongXa"].ToString() != "") newObject.PhuongXa = (string)row["PhuongXa"];
if (row["DiaChi"].ToString() != "") newObject.DiaChi = (string)row["DiaChi"];
if (row["GhiChu"].ToString() != "") newObject.GhiChu = (string)row["GhiChu"];
if (row["ImageUrl"].ToString() != "") newObject.ImageUrl = (string)row["ImageUrl"];
return newObject;
}
//Insert CongDan
public static int Insert(CongDan_Object newObject)
{
string InsertQuery = "Insert Into [CongDan]";
List<SqlParameter> paralist = new List<SqlParameter>();
string _val = "", _para = "";
if (newObject.HoTen != null)
{
_val += "HoTen, "; _para += "@HoTen, ";
paralist.Add(new SqlParameter("HoTen", newObject.HoTen));
}
if (newObject.NgaySinh != null)
{
_val += "NgaySinh, "; _para += "@NgaySinh, ";
paralist.Add(new SqlParameter("NgaySinh", newObject.NgaySinh));
}
if (newObject.GioiTinh != null)
{
_val += "GioiTinh, "; _para += "@GioiTinh, ";
paralist.Add(new SqlParameter("GioiTinh", newObject.GioiTinh));
}
_val += "SoCMND, "; _para += "@SoCMND, ";
paralist.Add(new SqlParameter("SoCMND", newObject.SoCMND));
if (newObject.SoHoChieu != null)
{
_val += "SoHoChieu, "; _para += "@SoHoChieu, ";
paralist.Add(new SqlParameter("SoHoChieu", newObject.SoHoChieu));
}
if (newObject.NgayCap != null)
{
_val += "NgayCap, "; _para += "@NgayCap, ";
paralist.Add(new SqlParameter("NgayCap", newObject.NgayCap));
}
if (newObject.NoiCap != null)
{
_val += "NoiCap, "; _para += "@NoiCap, ";
paralist.Add(new SqlParameter("NoiCap", newObject.NoiCap));
}
if (newObject.Id_TinhThanh != null)
{
_val += "Id_TinhThanh, "; _para += "@Id_TinhThanh, ";
paralist.Add(new SqlParameter("Id_TinhThanh", newObject.Id_TinhThanh));
}
if (newObject.Id_QuanHuyen != null)
{
_val += "Id_QuanHuyen, "; _para += "@Id_QuanHuyen, ";
paralist.Add(new SqlParameter("Id_QuanHuyen", newObject.Id_QuanHuyen));
}
if (newObject.PhuongXa != null)
{
_val += "PhuongXa, "; _para += "@PhuongXa, ";
paralist.Add(new SqlParameter("PhuongXa", newObject.PhuongXa));
}
if (newObject.DiaChi != null)
{
_val += "DiaChi, "; _para += "@DiaChi, ";
paralist.Add(new SqlParameter("DiaChi", newObject.DiaChi));
}
if (newObject.GhiChu != null)
{
_val += "GhiChu, "; _para += "@GhiChu, ";
paralist.Add(new SqlParameter("GhiChu", newObject.GhiChu));
}
if (newObject.ImageUrl != null)
{
_val += "ImageUrl, "; _para += "@ImageUrl, ";
paralist.Add(new SqlParameter("ImageUrl", newObject.ImageUrl));
}
InsertQuery += "(" + _val + ") Values (" + _para + ")";
InsertQuery = InsertQuery.Replace(", )", ")");
return commonDatabase.ExecuteNonQuerySQL(clsConnectionString.GetConnectionString(), InsertQuery, paralist);
}
//Select CongDan
public static List<CongDan_Object> SelectAll()
{
string SelectQuery = @"Select * from [CongDan]";
List<CongDan_Object> result = new List<CongDan_Object>();
DataTable tb = commonDatabase.GetSQLDataTable(clsConnectionString.GetConnectionString(), SelectQuery);
foreach (DataRow row in tb.Rows)
{
CongDan_Object newObject = new CongDan_Object();
if (row["HoTen"].ToString() != "") newObject.HoTen = (string)row["HoTen"];
if (row["NgaySinh"].ToString() != "") newObject.NgaySinh = (DateTime)row["NgaySinh"];
if (row["GioiTinh"].ToString() != "") newObject.GioiTinh = (string)row["GioiTinh"];
newObject.SoCMND = (string)row["SoCMND"];
if (row["SoHoChieu"].ToString() != "") newObject.SoHoChieu = (string)row["SoHoChieu"];
if (row["NgayCap"].ToString() != "") newObject.NgayCap = (DateTime)row["NgayCap"];
if (row["NoiCap"].ToString() != "") newObject.NoiCap = (string)row["NoiCap"];
if (row["Id_TinhThanh"].ToString() != "") newObject.Id_TinhThanh = (int)row["Id_TinhThanh"];
if (row["Id_QuanHuyen"].ToString() != "") newObject.Id_QuanHuyen = (int)row["Id_QuanHuyen"];
if (row["PhuongXa"].ToString() != "") newObject.PhuongXa = (string)row["PhuongXa"];
if (row["DiaChi"].ToString() != "") newObject.DiaChi = (string)row["DiaChi"];
if (row["GhiChu"].ToString() != "") newObject.GhiChu = (string)row["GhiChu"];
if (row["ImageUrl"].ToString() != "") newObject.ImageUrl = (string)row["ImageUrl"];
result.Add(newObject);
}
return result;
}
//Save changes of an Object to database CongDan
public static int SaveChanged(CongDan_Object UpdatingObject)
{
List<SqlParameter> paralist = new List<SqlParameter>();
string UpdateQuery =
@"Update CongDan SET
HoTen= @HoTen,
NgaySinh= @NgaySinh,
GioiTinh= @GioiTinh,
SoHoChieu= @SoHoChieu,
NgayCap= @NgayCap,
NoiCap= @NoiCap,
Id_TinhThanh= @Id_TinhThanh,
Id_QuanHuyen= @Id_QuanHuyen,
PhuongXa= @PhuongXa,
DiaChi= @DiaChi,
GhiChu= @GhiChu,
ImageUrl= @ImageUrl
Where SoCMND= @SoCMND";
paralist.Add(new SqlParameter("HoTen", UpdatingObject.HoTen));
paralist.Add(new SqlParameter("NgaySinh", UpdatingObject.NgaySinh));
paralist.Add(new SqlParameter("GioiTinh", UpdatingObject.GioiTinh));
paralist.Add(new SqlParameter("SoCMND", UpdatingObject.SoCMND));
paralist.Add(new SqlParameter("SoHoChieu", UpdatingObject.SoHoChieu));
paralist.Add(new SqlParameter("NgayCap", UpdatingObject.NgayCap));
paralist.Add(new SqlParameter("NoiCap", UpdatingObject.NoiCap));
paralist.Add(new SqlParameter("Id_TinhThanh", UpdatingObject.Id_TinhThanh));
paralist.Add(new SqlParameter("Id_QuanHuyen", UpdatingObject.Id_QuanHuyen));
paralist.Add(new SqlParameter("PhuongXa", UpdatingObject.PhuongXa));
paralist.Add(new SqlParameter("DiaChi", UpdatingObject.DiaChi));
paralist.Add(new SqlParameter("GhiChu", UpdatingObject.GhiChu));
paralist.Add(new SqlParameter("ImageUrl", UpdatingObject.ImageUrl));
return commonDatabase.ExecuteNonQuerySQL(clsConnectionString.GetConnectionString(), UpdateQuery, paralist);
}