public static PhieuPhat MappingPhieuPhat(this PhieuPhatDTO ppDTO)
{
if (!(ppDTO.ChiTietPhieuPhats == null))
{
return(new PhieuPhat
{
MaPP = ppDTO.MaPP,
MaDG = ppDTO.MaDG,
TongPhiPhat = ppDTO.TongPhiPhat,
UserId = ppDTO.UserId,
trangthai = ppDTO.trangthai,
ChiTietPhieuPhats = ppDTO.ChiTietPhieuPhats.MappingCTPPs().ToList()
});
}
else
{
return(new PhieuPhat
{
MaPP = ppDTO.MaPP,
MaDG = ppDTO.MaDG,
TongPhiPhat = ppDTO.TongPhiPhat,
UserId = ppDTO.UserId,
trangthai = ppDTO.trangthai,
});
}
}
public void UpdatePhieuPhat(PhieuPhatDTO phieuphatDTO)
{
var phieuphat = phieuphatRepository.GetBy(phieuphatDTO.MaPP);
phieuphatDTO.MappingPhieuPhat(phieuphat);
phieuphatRepository.Update(phieuphat);
}
public static void MappingPhieuPhat(this PhieuPhatDTO ppDTO, PhieuPhat pp)
{
pp.MaPP = ppDTO.MaPP;
pp.MaDG = ppDTO.MaDG;
pp.TongPhiPhat = ppDTO.TongPhiPhat;
pp.UserId = ppDTO.UserId;
pp.trangthai = ppDTO.trangthai;
if (ppDTO.ChiTietPhieuPhats != null)
{
pp.ChiTietPhieuPhats = ppDTO.ChiTietPhieuPhats.MappingCTPPs().ToList();
}
}
public IActionResult Index(string sortOrder, string searchString, int pageIndex = 1)
{
int pageSize = 8;
int count;
var dsphieuphat = phieuPhatService.GetPhieuPhats(sortOrder, searchString, pageIndex, pageSize, out count);
var phieuphat = new PhieuPhatDTO();
var ctpp = new ChiTietPhieuPhatDTO();
var phieuphatVM = new PhieuPhatIndexVm()
{
PhieuPhats = new PaginatedList <PhieuPhatDTO>(dsphieuphat, count, pageIndex, pageSize),
SearchString = searchString,
SortOrder = sortOrder,
phieuphat = phieuphat,
ctpp = ctpp
};
return(View(phieuphatVM));
}
public static void Insert(PhieuPhatDTO PhieuPhat)
{
OleDbConnection connection = DataProvider.CreateConnection();
string cmdText = "Insert into PhieuPhat(MaDG, TenPhieu, SoTienThu) values(?, ?, ?)";
OleDbCommand command = new OleDbCommand(cmdText, connection);
command.Parameters.Add("@MaDG", OleDbType.Integer);
command.Parameters.Add("@TenPhieu", OleDbType.VarWChar);
command.Parameters.Add("@SoTienThu", OleDbType.Integer);
command.Parameters["@MaDG"].Value = PhieuPhat.MaDocGia;
command.Parameters["@TenPhieu"].Value = PhieuPhat.TenPhieu;
command.Parameters["@SoTienThu"].Value = PhieuPhat.SoTien;
command.ExecuteNonQuery();
command.CommandText = "select @@IDENTITY";
PhieuPhat.MaPhieuPhat = (int)command.ExecuteScalar();
connection.Close();
}
public static IList GetList()
{
ArrayList arrList = new ArrayList();
PhieuPhatDTO PhieuPhat = null;
OleDbConnection connection = DataProvider.CreateConnection();
string cmdText = "Select * from PHIEUPHAT";
OleDbCommand command = new OleDbCommand(cmdText, connection);
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
PhieuPhat = new PhieuPhatDTO();
PhieuPhat.MaPhieuPhat = (int)reader["MaPhieuPhat"];
PhieuPhat.MaDocGia = (int)reader["MaDG"];
PhieuPhat.TenPhieu = (string)reader["TenPhieu"];
PhieuPhat.SoTien = (long)reader["SoTienThu"];
arrList.Add(PhieuPhat);
}
reader.Close();
connection.Close();
return(arrList);
}
public void CreatePhieuPhat(PhieuPhatDTO phieuphatDTO)
{
var phieuphat = phieuphatDTO.MappingPhieuPhat();
phieuphatRepository.Add(phieuphat);
}
