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); }