public Models.QueueRollModel GetQueueRoll(Models.QueueRollModel QueueRoll)
{
var dbCon = DBConnection;
if (dbCon.IsConnect())
{
string query = string.Format("SELECT rollid, queueid, employeeid, taskid, startdate, stopdate, minutes, rate FROM queueroll where rollid={0}", QueueRoll.RollId);
var cmd = new MySqlCommand(query, dbCon.Connection);
var reader = cmd.ExecuteReader();
EmployeeQueries EmployeeQuery = new EmployeeQueries();
TaskQueries TaskQuery = new TaskQueries();
while (reader.Read())
{
QueueRoll.RollId = int.Parse(reader["rollid"].ToString());
QueueRoll.QueueId = int.Parse(reader["queueid"].ToString());
QueueRoll.EmployeeId = int.Parse(reader["employeeid"].ToString());
QueueRoll.TaskId = int.Parse(reader["taskid"].ToString());
QueueRoll.Employee = EmployeeQuery.GetEmployee(QueueRoll.EmployeeId);
QueueRoll.Task = TaskQuery.GetTask(QueueRoll.TaskId);
}
dbCon.Close();
}
return(QueueRoll);
}
public List <Models.QueueRollModel> GetQueuesRoll()
{
List <Models.QueueRollModel> QueuesRoll = new List <Models.QueueRollModel>();
var dbCon = DBConnection;
if (dbCon.IsConnect())
{
string query = string.Format("SELECT rollid, queueid, employeeid, taskid, startdate, stopdate, minutes, rate FROM queueroll");
var cmd = new MySqlCommand(query, dbCon.Connection);
var reader = cmd.ExecuteReader();
EmployeeQueries EmployeeQuery = new EmployeeQueries();
TaskQueries TaskQuery = new TaskQueries();
while (reader.Read())
{
Models.QueueRollModel Queue = new Models.QueueRollModel
{
QueueId = int.Parse(reader["queueid"].ToString()),
EmployeeId = int.Parse(reader["employeeid"].ToString()),
TaskId = int.Parse(reader["taskid"].ToString()),
Employee = EmployeeQuery.GetEmployee(int.Parse(reader["employeeid"].ToString())),
Task = TaskQuery.GetTask(int.Parse(reader["taskid"].ToString()))
};
QueuesRoll.Add(Queue);
}
dbCon.Close();
}
return(QueuesRoll);
}
public List <Models.QueueRollModel> GetQueuesRoll(List <Models.QueueRollModel> QueuesRoll, int EmployeeId, bool isAdmin)
{
var dbCon = DBConnection;
if (dbCon.IsConnect())
{
string query = "";
if (isAdmin == true)
{
query = string.Format("SELECT rollid, queueid, employeeid, taskid, startdate, stopdate, minutes, rate FROM queueroll");
}
else
{
query = string.Format("SELECT rollid, queueid, employeeid, taskid, startdate, stopdate, minutes, rate FROM queueroll where employeeid={0}", EmployeeId);
}
var cmd = new MySqlCommand(query, dbCon.Connection);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
Models.QueueRollModel Queue = new Models.QueueRollModel
{
RollId = int.Parse(reader["rollid"].ToString()),
QueueId = int.Parse(reader["queueid"].ToString()),
EmployeeId = int.Parse(reader["employeeid"].ToString()),
TaskId = int.Parse(reader["taskid"].ToString()),
StartDate = DateTime.Parse(reader["startdate"].ToString()),
StopDate = DateTime.Parse(reader["stopdate"].ToString()),
Minutes = double.Parse(reader["minutes"].ToString()),
Rate = decimal.Parse(reader["rate"].ToString()),
};
QueuesRoll.Add(Queue);
}
dbCon.Close();
}
return(QueuesRoll);
}
public Models.QueueRollModel UpdateQueueRoll(Models.QueueRollModel QueueRoll)
{
var dbCon = DBConnection;
if (dbCon.IsConnect())
{
string query = string.Format("UPDATE queueroll set queueid='{0}', employeeid='{1}', taskid='{2}', startdate='{3}', stopdate='{4}', minutes='{5}', rate='{6}' WHERE rollid={7};", QueueRoll.QueueId, QueueRoll.EmployeeId, QueueRoll.TaskId, QueueRoll.StartDate, QueueRoll.StopDate, QueueRoll.Minutes, QueueRoll.Rate, QueueRoll.RollId);
if (dbCon.Connection.State.ToString() == "Closed")
{
dbCon.Connection.Open();
}
var cmd = new MySqlCommand(query, dbCon.Connection);
var reader = cmd.ExecuteNonQuery();
dbCon.Close();
}
return(QueueRoll);
}
public Models.QueueRollModel CreateQueueRoll(Models.QueueRollModel QueueRoll)
{
var dbCon = DBConnection;
if (dbCon.IsConnect())
{
string query = string.Format("INSERT INTO queueroll (queueid, employeeid, taskid, startdate, stopdate, minutes, rate) VALUES('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}');", QueueRoll.QueueId, QueueRoll.EmployeeId, QueueRoll.TaskId, QueueRoll.StartDate, QueueRoll.StopDate, QueueRoll.Minutes, QueueRoll.Rate);
if (dbCon.Connection.State.ToString() == "Closed")
{
dbCon.Connection.Open();
}
var cmd = new MySqlCommand(query, dbCon.Connection);
var reader = cmd.ExecuteNonQuery();
dbCon.Close();
}
return(QueueRoll);
}
