public bool DeletePhieuChi(DTO.PhieuChi pc)
{
string query = string.Empty;
query += "DELETE FROM PHIEUCHI WHERE [MAPHIEUCHI] = @maPhieuChi";
using (SqlConnection con = dc.GetConnect())
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@maPhieuChi", pc.mapc);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(false);
}
}
}
return(true);
}
public bool InsertPhieuChi(DTO.PhieuChi pc)
{
string sql = "INSERT INTO PHIEUCHI(MAPHIEUCHI, id_Nhan_Vien,TENPC,SOTIEN,NOIDUNG,THOIGIAN) VALUES(@MAPCHI, @ID,@TEN,@TIEN,@ND,@TIME)";
SqlConnection con = dc.GetConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MAPCHI", SqlDbType.VarChar).Value = TaoMaPhieuChi();
cmd.Parameters.Add("@ID", SqlDbType.NVarChar).Value = pc.manv;
cmd.Parameters.Add("@TEN", SqlDbType.NVarChar).Value = pc.tenpc;
cmd.Parameters.Add("@TIEN", SqlDbType.Decimal).Value = pc.giapc;
cmd.Parameters.Add("@ND", SqlDbType.NVarChar).Value = pc.noidung;
cmd.Parameters.Add("@TIME", SqlDbType.DateTime).Value = pc.thoigian;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool DeletePhieuChi(DTO.PhieuChi pc)
{
return(dalPC.DeletePhieuChi(pc));
}
public bool InsertPhieuChi(DTO.PhieuChi pc)
{
return(dalPC.InsertPhieuChi(pc));
}
