///// <summary>
///// get list
///// </summary>
///// <returns></returns>
//public DataSet GetListPhieuChiTieu()
//{
// using (conn )
// {
// if (conn.State == ConnectionState.Closed)
// conn.Open();
// SqlCommand command = conn.CreateCommand();
// command.CommandType = CommandType.StoredProcedure;
// command.CommandText = "GetListPhieuChiTieu";
// SqlDataAdapter adapter = new SqlDataAdapter(command);
// DataSet dataset = new DataSet();
// adapter.Fill(dataset);
// return dataset;
// }
//}
public List <PhieuChiTieu> GetListPhieuChiTieu()
{
List <PhieuChiTieu> list = new List <PhieuChiTieu>();
using (conn = new SqlConnection(connString))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand command = conn.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "GetListPhieuChiTieu";
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable dt = new DataTable();
adapter.Fill(dt);
PhieuChiTieu hs;
foreach (DataRow dr in dt.Rows)
{
hs = new PhieuChiTieu();
hs.MaNhanVien = Convert.ToString(dr["MaNhanVien"]);
hs.MaPhieuChiTieu = Convert.ToString(dr["MaPhieuChiTieu"]);
hs.NgayTaoPhieu = Convert.ToDateTime(dr["NgayTaoPhieu"]);
hs.LyDo = Convert.ToString(dr["LyDo"]);
hs.ChiPhi = Convert.ToDecimal(dr["ChiPhi"]);
list.Add(hs);
}
}
return(list);
}
/// <summary>
/// edit
/// </summary>
/// <param name="phieuchitieu"></param>
public void EditPhieuChiTieu(PhieuChiTieu phieuchitieu)
{
using (conn = new SqlConnection(connString))
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
SqlCommand command = conn.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "InsertUpdatePhieuChiTieu";
command.Parameters.Add("@MaPhieuChiTieu", SqlDbType.VarChar, 20).Value = phieuchitieu.MaPhieuChiTieu;
command.Parameters.Add("@NgayTaoPhieu", SqlDbType.Date).Value = phieuchitieu.NgayTaoPhieu;
command.Parameters.Add("@MaNhanVien", SqlDbType.VarChar, 20).Value = phieuchitieu.MaNhanVien;
command.Parameters.Add("@LyDo", SqlDbType.NVarChar, 100).Value = phieuchitieu.LyDo;
command.Parameters.Add("@ChiPhi", SqlDbType.Money).Value = phieuchitieu.ChiPhi;
command.Parameters.Add("@Action", SqlDbType.VarChar, 10).Value = "Update";
try
{
command.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
command.Dispose();
conn.Dispose();
}
}
}
/// <summary>
/// add
/// </summary>
/// <param name="phieuchitieu"></param>
public void AddPhieuChiTieu(PhieuChiTieu phieuchitieu)
{
phieuchitieu.MaPhieuChiTieu = AutoIdPhieuChiTieu();
using (conn = new SqlConnection(connString))
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
SqlCommand command = conn.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "InsertUpdatePhieuChiTieu";
command.Parameters.AddWithValue("@MaPhieuChiTieu", phieuchitieu.MaPhieuChiTieu);
command.Parameters.AddWithValue("@NgayTaoPhieu", phieuchitieu.NgayTaoPhieu);
command.Parameters.AddWithValue("@MaNhanVien", phieuchitieu.MaNhanVien);
command.Parameters.AddWithValue("@LyDo", phieuchitieu.LyDo);
command.Parameters.AddWithValue("@ChiPhi", phieuchitieu.ChiPhi);
command.Parameters.AddWithValue("@Action", "Insert");
try
{
command.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
command.Dispose();
conn.Dispose();
}
}
}
/// <summary>
/// hàm thục thi excute
/// </summary>
/// <param name="parameter"></param>
private void OnExcutePTC(object parameter)
{
var obj = (object[])parameter;
var window = (Window)obj[0];
var wrap = (WrapPanel)obj[1];
PhieuChiTieuDaoImpl impl = new PhieuChiTieuDaoImpl();
PhieuChiTieu ptc = new PhieuChiTieu();
try
{
foreach (var item in (wrap as WrapPanel).Children)
{
string name = null;
if (item is FrameworkElement)
{
name = (item as FrameworkElement).Name;
switch (name)
{
case "txbMaPhieu":
ptc.MaPhieuChiTieu = (item as TextBlock).Text;
break;
case "dtNgay":
ptc.NgayTaoPhieu = (item as DatePicker).SelectedDate.Value;
break;
case "txtMaNV":
ptc.MaNhanVien = (item as TextBox).Text;
break;
case "nbChiPhi":
ptc.ChiPhi = (decimal)(item as NumericUpDown).Value.GetValueOrDefault();
break;
case "txtLyDo":
ptc.LyDo = (item as TextBox).Text;
break;
}
}
}
if (string.IsNullOrEmpty(ptc.MaPhieuChiTieu))
{
// theem moi
impl.AddPhieuChiTieu(ptc);
MessageBox.Show("Thêm mói thành công");
}
else
{
// suawr
impl.EditPhieuChiTieu(ptc);
MessageBox.Show("Sửa thành công");
}
window.DataContext = new PhieuChiTieuViewModel();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
/// hàm delete
/// </summary>
/// <param name="parameter"></param>
private void OnDeletePTC(object parameter)
{
var obj = (object[])parameter;
var window = (Window)obj[0];
var datagrid = (DataGrid)obj[1];
PhieuChiTieuDaoImpl impl = new PhieuChiTieuDaoImpl();
try
{
PhieuChiTieu ptc = new PhieuChiTieu();
ptc = datagrid.SelectedItem as PhieuChiTieu;
impl.DeletePhieuChiTieu(ptc.MaPhieuChiTieu);
window.DataContext = new PhieuChiTieuViewModel();
MessageBox.Show("Xóa thành công!");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
