public string Them(BangGiaTheoGoiBDO entityBDO) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString(tenDB))) { var p = new DynamicParameters(); //Của dapper p.Add("@Ten", entityBDO.Ten); p.Add("@DienGiai", entityBDO.DienGiai); p.Add("@DaySoLuong", entityBDO.DaySoLuong); p.Add("@DayGia", entityBDO.DayGia); p.Add("@DonViTinh", entityBDO.DonViTinh); p.Add("@ThuTu", entityBDO.ThuTu); p.Add("@KhongCon", entityBDO.KhongCon); p.Add("@LoaiBangGia", entityBDO.LoaiBangGia); p.Add("@id", dbType: DbType.Int32, direction: ParameterDirection.Output); //Excecute connection.Execute("dbo.spBangGiaTheoGoi_Them", p, commandType: CommandType.StoredProcedure); //xử lý id out entityBDO.Id = p.Get <int>("@id"); ///nếu cần có thể ///đặt return ở đay cũng được } return("Đã thêm"); }
public BangGiaTheoGoiBDO DocTheoId(int iD) { BangGiaTheoGoiBDO output = null; using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString(tenDB))) { var p = new DynamicParameters(); p.Add("@id", iD); output = connection.QueryFirstOrDefault <BangGiaTheoGoiBDO>("dbo.spBangGiaTheoGoi_DocTheoId", p, commandType: CommandType.StoredProcedure);//Thử return(output); } }
public string Sua(BangGiaTheoGoiBDO entityBDO) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString(tenDB))) { var p = new DynamicParameters(); //Của dapper p.Add("@id", entityBDO.Id); p.Add("@Ten", entityBDO.Ten); p.Add("@DienGiai", entityBDO.DienGiai); p.Add("@DaySoLuong", entityBDO.DaySoLuong); p.Add("@DayGia", entityBDO.DayGia); p.Add("@DonViTinh", entityBDO.DonViTinh); p.Add("@ThuTu", entityBDO.ThuTu); p.Add("@KhongCon", entityBDO.KhongCon); p.Add("@LoaiBangGia", entityBDO.LoaiBangGia); connection.Execute("dbo.spBangGiaTheoGoi_SuaTheoId", p, commandType: CommandType.StoredProcedure); } return($"Đã sửa {entityBDO.Id}"); }
public string Sua(BangGiaTheoGoiBDO bangGiaBDO) { return(bangGiaDAO.Sua(bangGiaBDO)); }
public string Them(BangGiaTheoGoiBDO bangGiaBDO) { return(bangGiaDAO.Them(bangGiaBDO)); }