public static bool CheckExistsChamCong(DTO.ChamCongDTO cc)
{
DataTable tb = new DataTable();
string query = "Select TOP 1 cc.MaChamCong From ChamCong cc where cc.Thang=" + cc.Thang + " and cc.Nam=" + cc.Nam + " Order by cc.MaChamCong DESC";
DataProvider dataProvider = new DataProvider();
try
{
dataProvider.connect();
tb = dataProvider.ExecuteQuery_DataTble(query);
dataProvider.disconnect();
if (tb.Rows.Count == 0)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
dataProvider.disconnect();
}
return(false);
}
public static void AddChamCong(DTO.ChamCongDTO cc)
{
string query = " INSERT INTO ChamCong(MaChamCong, Thang, Nam, NgayPhatLuong) VALUES('" + cc.MaChamCong + "', " + cc.Thang.ToString() + ", " + cc.Nam + ", '" + cc.NgayPhatLuong.ToString("yyyy-MM-dd") + "')";
DataProvider dataProvider = new DataProvider();
try
{
dataProvider.connect();
dataProvider.ExecuteUpdateQuery(query);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
dataProvider.disconnect();
}
}
public static bool CheckExistsChamCong(DTO.ChamCongDTO cc)
{
return(DAO.ChamCongDAO.CheckExistsChamCong(cc));
}
private void btnOK_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog fopen = new OpenFileDialog();
fopen.Filter = "Excel|*.xlsx";
fopen.ShowDialog();
if (fopen.FileName != "")
{
tbAlert.Text = "Đang tải dữ liệu chấm công...";
Excel.Application app = new Excel.Application();
Excel.Workbook wb = app.Workbooks.Open(fopen.FileName);
Excel.Worksheet sheet = null;
try
{
sheet = wb.Sheets[1];
Excel.Range range = sheet.UsedRange;
DTO.ChamCongDTO chamCong = new DTO.ChamCongDTO();
string maccLast = "";
if (BUS.ChamCongBUS.GetLastChamCong().Rows.Count > 0)
{
maccLast = BUS.ChamCongBUS.GetLastChamCong().Rows[0][0].ToString();
}
chamCong.MaChamCong = NextID(maccLast, "CC");
chamCong.Thang = Convert.ToInt16(range.Cells[2, 3].Text.ToString());
chamCong.Nam = Convert.ToInt16(range.Cells[2, 4].Text.ToString());
chamCong.NgayPhatLuong = Convert.ToDateTime("5/" + chamCong.Thang.ToString() + "/" + chamCong.Nam.ToString());
if (BUS.ChamCongBUS.CheckExistsChamCong(chamCong))
{
tbAlert.Text = "Dữ liệu chấm công " + chamCong.Thang + "/" + chamCong.Nam + " đã tồn tại!";
}
else
{
int rows = range.Rows.Count;
int cols = range.Columns.Count;
DataTable dtTableTemp = new DataTable();
dtTableTemp.Columns.Add("MaNV");
dtTableTemp.Columns.Add("NgayCong");
for (int i = 10; i <= rows; i++)
{
DataRow dtRow = dtTableTemp.NewRow();
if (string.IsNullOrEmpty(range.Cells[i, 117].Text.ToString()))
{
break;
}
else
{
dtRow[0] = range.Cells[i, 117].Value;
dtRow[1] = range.Cells[i, 131].Value;
}
dtTableTemp.Rows.Add(dtRow);
}
BUS.ChamCongBUS.AddChamCong(chamCong);
BUS.ChiTietChamCongBUS.AddCTCC(dtTableTemp, chamCong.MaChamCong);
tbAlert.Text = "Tải dữ liệu chấm công hoàn thành!";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Thông báo", MessageBoxButton.OK, MessageBoxImage.Error);
}
finally
{
wb = null; app.Quit();
}
}
}
public static void AddChamCong(DTO.ChamCongDTO cc)
{
DAO.ChamCongDAO.AddChamCong(cc);
}
