public ClientCodeRates GetClientCodeBillableRate(ClientCode code, BillableService service)
{
SqlServerConnection conn = new SqlServerConnection();
SqlDataReader dr = conn.SqlServerConnect("SELECT bs_idnt, bs_concept, bs_service, bs_amount, bs_description, ISNULL(cr_rate, bs_amount)x FROM BillableService LEFT OUTER JOIN ClientCodesRates ON bs_idnt=cr_service AND cr_code=" + code.Id + " WHERE bs_idnt=" + service.Id);
if (dr.Read())
{
return new ClientCodeRates {
Service = new BillableService
{
Id = Convert.ToInt64(dr[0]),
Concept = new Concept {
Id = Convert.ToInt64(dr[1])
},
Name = dr[2].ToString(),
Amount = Convert.ToDouble(dr[3]),
Description = dr[4].ToString()
},
Code = code,
Amount = Convert.ToDouble(dr[5]),
}
}
;
return(new ClientCodeRates());
}
public Room()
{
Id = 0;
Void = false;
Name = "";
Type = new RoomType();
Concept = new Concept();
Service = new BillableService();
}
public List <Room> GetRooms(RoomType type, Concept concept, BillableService service, bool includeVoid = false, string conditions = "", string filter = "")
{
List <Room> rooms = new List <Room>();
SqlServerConnection conn = new SqlServerConnection();
string query = "";
if (type != null)
{
query = "WHERE rm_type=" + type.Id;
}
if (concept != null)
{
query += (query == "" ? "WHERE " : " AND ") + "rm_concept=" + concept.Id;
}
if (service != null)
{
query += (query == "" ? "WHERE " : " AND ") + "rm_service=" + service.Id;
}
if (!includeVoid)
{
query += (query == "" ? "WHERE " : " AND ") + "rm_void=0";
}
if (!string.IsNullOrEmpty(conditions))
{
query += (query == "" ? "WHERE " : " AND ") + conditions;
}
if (!string.IsNullOrEmpty(filter))
{
query += conn.GetQueryString(filter, "rm_room+'-'+rt_type+'-'+bs_service+'-'+CAST(bs_amount AS NVARCHAR)", "", true, false);
}
SqlDataReader dr = conn.SqlServerConnect("SELECT rm_idnt, rm_void, rm_room, rm_concept, rt_idnt, rt_void, rt_concept, rt_type, ISNULL(bs_idnt,0), bs_code, ISNULL(bs_concept,0), bs_service, ISNULL(bs_amount,0), bs_description FROM Rooms INNER JOIN RoomType ON rm_type=rt_idnt LEFT OUTER JOIN BillableService ON rm_service=bs_idnt " + query);
if (dr.HasRows)
{
while (dr.Read())
{
rooms.Add(new Room {
Id = Convert.ToInt64(dr[0]),
Void = Convert.ToBoolean(dr[1]),
Name = dr[2].ToString(),
Concept = new Concept {
Id = Convert.ToInt64(dr[3])
},
Type = new RoomType {
Id = Convert.ToInt64(dr[4]),
Void = Convert.ToBoolean(dr[5]),
Concept = new Concept {
Id = Convert.ToInt64(dr[6])
},
Name = dr[7].ToString(),
},
Service = new BillableService {
Id = Convert.ToInt64(dr[8]),
Code = dr[9].ToString(),
Concept = new Concept {
Id = Convert.ToInt64(dr[10])
},
Name = dr[11].ToString(),
}
});
}
}
return(rooms);
}
