public Boolean insertLeaveRight(enLeaveRight enLeaveRight) { try { str = "INSERT INTO leaveRight (personalID,year,description,leaveAmount,usedLeaveAmount,balanceLeaveAmount)VALUES(@personalID,@year,@description,@leaveAmount,@usedLeaveAmount,@balanceLeaveAmount);"; Dbcmd = db.GetSqlStringCommand(str); db.AddInParameter(Dbcmd, "@personalID", DbType.Int32, enLeaveRight.personalID); db.AddInParameter(Dbcmd, "@year", DbType.String, enLeaveRight.year); db.AddInParameter(Dbcmd, "@description", DbType.String, enLeaveRight.description); db.AddInParameter(Dbcmd, "@leaveAmount", DbType.Int32, enLeaveRight.leaveAmount); db.AddInParameter(Dbcmd, "@usedLeaveAmount", DbType.Int32, enLeaveRight.usedLeaveAmount); db.AddInParameter(Dbcmd, "@balanceLeaveAmount", DbType.Int32, enLeaveRight.balanceLeaveAmount); db.ExecuteNonQuery(Dbcmd); return true; } catch (Exception ex) { throw new Exception(ex.Message); } }
public Boolean updateLeaveRight(enLeaveRight enLeaveRight) { try { str = "UPDATE leaveRight SET personalID=@personalID,year=@year,description=@description,leaveAmount=@leaveAmount,usedLeaveAmount=@usedLeaveAmount,balanceLeaveAmount=@balanceLeaveAmount WHERE leaveRightID=@leaveRightID;"; Dbcmd = db.GetSqlStringCommand(str); db.AddInParameter(Dbcmd, "@personalID", DbType.Int32, enLeaveRight.personalID); db.AddInParameter(Dbcmd, "@year", DbType.String, enLeaveRight.year); db.AddInParameter(Dbcmd, "@description", DbType.String, enLeaveRight.description); db.AddInParameter(Dbcmd, "@leaveAmount", DbType.Int32, enLeaveRight.leaveAmount); db.AddInParameter(Dbcmd, "@usedLeaveAmount", DbType.Int32, enLeaveRight.usedLeaveAmount); db.AddInParameter(Dbcmd, "@balanceLeaveAmount", DbType.Int32, enLeaveRight.balanceLeaveAmount); db.AddInParameter(Dbcmd, "@leaveRightID", DbType.Int32, enLeaveRight.leaveRightID); db.ExecuteNonQuery(Dbcmd); return true; } catch (Exception ex) { throw new Exception(ex.Message); } }