public void InsertTimeSheet(DTO_PhieuChamCong TimeSheet)
{
OracleCommand command = new OracleCommand($"{_dbSchema}.INSERT_PCC", _conn);
command.CommandType = CommandType.StoredProcedure;
OracleParameter param1 = new OracleParameter("I_THOIGIAN", OracleDbType.Varchar2);
param1.Value = TimeSheet.ThoiGian;
OracleParameter param2 = new OracleParameter("I_SONGAYCONG", OracleDbType.Int16);
param2.Value = TimeSheet.SoNgayCong;
OracleParameter param3 = new OracleParameter("I_TIENLUONG", OracleDbType.Double);
param2.Value = TimeSheet.TienLuong;
command.Parameters.Add(param1);
command.Parameters.Add(param2);
command.Parameters.Add(param3);
try
{
_conn.Open();
command.ExecuteNonQuery();
_conn.Close();
}
catch (OracleException e)
{
_conn.Close();
throw new Exception(e.Message);
}
}
public List <DTO_PhieuChamCong> GetTimeSheets()
{
List <DTO_PhieuChamCong> result = new List <DTO_PhieuChamCong>();
DataTable data = DAO_PhieuChamCong.Instance.GetTimeSheets();
foreach (DataRow row in data.Rows)
{
DTO_PhieuChamCong tmpObject = new DTO_PhieuChamCong();
tmpObject.MaNhanVien = row["MANHANVIEN"].ToString();
DateTime date = DateTime.Parse(row["THOIGIANCHAMCONG"].ToString());
tmpObject.ThoiGian = date.ToString("dd/MM/yyyy");
tmpObject.SoNgayCong = int.Parse(row["SONGAYCONG"].ToString());
tmpObject.TienLuong = double.Parse(row["TIENLUONG"].ToString());
result.Add(tmpObject);
}
return(result);
}
