public static clsListMessages getMessages(int employeeID)
{
clsListMessages tmp = new clsListMessages();
IRemaxData rmx = new clsRemaxData();
DataTable tab = null;
tab = rmx.getMessages(employeeID);
foreach (DataRow rowMessage in tab.Rows)
{
clsMessage msg = new clsMessage(Convert.ToInt32(rowMessage["ID"]), Convert.ToInt32(rowMessage["employee"]), rowMessage["message"].ToString(),
Convert.ToByte(rowMessage["status"]), Convert.ToDateTime(rowMessage["messagedate"]));
tmp.Add(msg, msg.ID);
msg = null;
}
tab = null;
return(tmp);
}
public static clsListClients getClientsNeedConnectToHouse()
{
clsListClients tmp = new clsListClients();
IRemaxData rmx = new clsRemaxData();
DataTable tab = null;
tab = rmx.getClientsNeedConnectToHouse();
foreach (DataRow rowClient in tab.Rows)
{
clsClient cl = new clsClient(Convert.ToInt32(rowClient["ID"].ToString()), rowClient["fullname"].ToString(),
rowClient["phone"].ToString(), rowClient["email"].ToString(),
(enumClientType)Enum.Parse(typeof(enumClientType), rowClient["type"].ToString()));
tmp.Add(cl, cl.ID);
cl = null;
}
tab = null;
return(tmp);
}
public static clsListHouses getHouses()
{
clsListHouses tmp = new clsListHouses();
IRemaxData rmx = new clsRemaxData();
DataTable tab = null;
tab = rmx.getHouses();
foreach (DataRow rowHouse in tab.Rows)
{
//Get client for house
clsClient client = null;
if (Convert.ToInt32(rowHouse["client"].ToString()) > 0)
{
DataRow rowClient = rmx.getClient(Convert.ToInt32(rowHouse["client"].ToString()));
if (rowClient != null)
{
client = new clsClient(Convert.ToInt32(rowClient["ID"].ToString()), rowClient["fullname"].ToString(),
rowClient["phone"].ToString(), rowClient["email"].ToString(),
(enumClientType)Enum.Parse(typeof(enumClientType), rowClient["type"].ToString()), null);
}
}
clsHouse house = new clsHouse(Convert.ToInt32(rowHouse["id"].ToString()), rowHouse["code"].ToString(),
Convert.ToSingle(rowHouse["aria"].ToString()), Convert.ToByte(rowHouse["rooms"].ToString()),
Convert.ToByte(rowHouse["bathrooms"].ToString()), (enumCityzone)Enum.Parse(typeof(enumCityzone), rowHouse["cityzone"].ToString()),
rowHouse["address"].ToString(), Convert.ToSingle(rowHouse["price"].ToString()), rowHouse["description"].ToString(),
(enumHouseType)Enum.Parse(typeof(enumHouseType), rowHouse["type"].ToString()), rowHouse["pic"].ToString(),
(enumHouseStatus)Enum.Parse(typeof(enumHouseStatus), rowHouse["status"].ToString()), Convert.ToDateTime(rowHouse["datein"]),
client, Convert.ToInt32(rowHouse["employee"].ToString()));
tmp.Add(house, house.Code);
house = null;
}
tab = null;
return(tmp);
}
public static clsListEmployees GetEmployees()
{
clsListEmployees tmp = new clsListEmployees();
IRemaxData rmx = new clsRemaxData();
DataTable tab = null;
tab = rmx.getEmployees();
foreach (DataRow row in tab.Rows)
{
clsEmployee emp = new clsEmployee(Convert.ToInt32(row["id"].ToString()), row["code"].ToString(), row["fullname"].ToString(),
(enumGender)Enum.Parse(typeof(enumGender), row["gender"].ToString()),
(enumCityzone)Enum.Parse(typeof(enumCityzone), row["cityzone"].ToString()),
row["username"].ToString(), row["password"].ToString(),
(enumEmployeeType)Enum.Parse(typeof(enumEmployeeType), row["type"].ToString()),
(enumLang)Enum.Parse(typeof(enumLang), row["lang"].ToString()), row["pic"].ToString());
tmp.Add(emp, emp.Code);
emp = null;
}
tab = null;
return(tmp);
}
public static clsListHouses getHousesForSales(int?agentID = null)
{
clsListHouses tmp = new clsListHouses();
IRemaxData rmx = new clsRemaxData();
DataTable tab = null;
tab = rmx.getHousesForSales(agentID);
foreach (DataRow rowHouse in tab.Rows)
{
clsHouse house = new clsHouse(Convert.ToInt32(rowHouse["id"].ToString()), rowHouse["code"].ToString(),
Convert.ToSingle(rowHouse["aria"].ToString()), Convert.ToByte(rowHouse["rooms"].ToString()),
Convert.ToByte(rowHouse["bathrooms"].ToString()), (enumCityzone)Enum.Parse(typeof(enumCityzone), rowHouse["cityzone"].ToString()),
rowHouse["address"].ToString(), Convert.ToSingle(rowHouse["price"].ToString()), rowHouse["description"].ToString(),
(enumHouseType)Enum.Parse(typeof(enumHouseType), rowHouse["type"].ToString()), rowHouse["pic"].ToString(),
(enumHouseStatus)Enum.Parse(typeof(enumHouseStatus), rowHouse["status"].ToString()), Convert.ToDateTime(rowHouse["datein"]));
tmp.Add(house, house.Code);
house = null;
}
tab = null;
return(tmp);
}
public static int deleteMessage(int messageID)
{
IRemaxData rmx = new clsRemaxData();
return(rmx.deleteMessage(messageID));
}
public static int insertMessage(string messageToInsert)
{
IRemaxData rmx = new clsRemaxData();
return(rmx.insertMessage(messageToInsert));
}
public static int deleteEmployee(int emploueeID)
{
IRemaxData rmx = new clsRemaxData();
return(rmx.deleteEmployee(emploueeID));
}
public static int updateEmployee(int employeeID, string employeeToUpdate)
{
IRemaxData rmx = new clsRemaxData();
return(rmx.updateEmployee(employeeID, employeeToUpdate));
}
public static int insertEmployee(string employeeToInsert)
{
IRemaxData rmx = new clsRemaxData();
return(rmx.insertEmployee(employeeToInsert));
}
public static int updateHouse(int houseID, string houseToUpdate)
{
IRemaxData rmx = new clsRemaxData();
return(rmx.updateHouse(houseID, houseToUpdate));
}
public static int joinHouseToClient(int houseID, int clientID)
{
IRemaxData rmx = new clsRemaxData();
return(rmx.joinHouseToClient(houseID, clientID));
}
public static int insertClient(string clientToInsert)
{
IRemaxData rmx = new clsRemaxData();
return(rmx.insertClient(clientToInsert));
}
public static int updateClient(int clientID, string clientToUpdate)
{
IRemaxData rmx = new clsRemaxData();
return(rmx.updateClient(clientID, clientToUpdate));
}
public static int deleteClient(int clientID)
{
IRemaxData rmx = new clsRemaxData();
return(rmx.deleteClient(clientID));
}
public static int insertHouse(int employeeID, string houseToInsert)
{
IRemaxData rmx = new clsRemaxData();
return(rmx.insertHouse(houseToInsert + ", " + employeeID));
}
public static int insertSale(string saleToInsert)
{
IRemaxData rmx = new clsRemaxData();
return(rmx.insertSale(saleToInsert));
}
public static int deleteHouse(int houseID)
{
IRemaxData rmx = new clsRemaxData();
return(rmx.deleteHouse(houseID));
}
