public String GetUser(int User_id)
{
Query = "select um_User_Name from User_Master where um_User_Id = " + User_id;
DataTable ds = new DataTable();
ds = caObjects.ExecuteQueryReturnDataTable(Query);
return(ds.Rows[0][0].ToString());
}
public RackMaster[] GetRacks()
{
DataTable dt = new DataTable();
RackMaster[] rackMasters;
Query = "exec proc_GetRacks";
dt = caObjects.ExecuteQueryReturnDataTable(Query);
rackMasters = new RackMaster[dt.Rows.Count];
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
RackMaster rackMaster = new RackMaster();
rackMaster.rak_Rack_Id = Convert.ToInt32(dt.Rows[i]["rak_Rack_Id"]);
rackMaster.rak_Rack_Name = Convert.ToString(dt.Rows[i]["rak_Rack_Name"]);
rackMaster.rak_Rack_Number = Convert.ToString(dt.Rows[i]["rak_Rack_Number"]);
rackMasters[i] = rackMaster;
}
return(rackMasters);
}
public RoleMaster[] GetRoles()
{
DataTable dt = new DataTable();
RoleMaster[] roleMasters;
Query = "exec proc_GetRoles";
dt = caObjects.ExecuteQueryReturnDataTable(Query);
roleMasters = new RoleMaster[dt.Rows.Count];
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
RoleMaster roleMaster = new RoleMaster();
roleMaster.rm_RoleId = Convert.ToInt32(dt.Rows[i]["rm_RoleId"]);
roleMaster.rm_RoleName = Convert.ToString(dt.Rows[i]["rm_RoleName"]);
roleMaster.rm_Status = Convert.ToBoolean(dt.Rows[i]["rm_Status"]);
roleMasters[i] = roleMaster;
}
return(roleMasters);
}
public VehicleMaster[] GetVehicle()
{
DataTable dt = new DataTable();
VehicleMaster[] vehicleMasters;
Query = "exec proc_GetVehicle";
dt = caObjects.ExecuteQueryReturnDataTable(Query);
vehicleMasters = new VehicleMaster[dt.Rows.Count];
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
VehicleMaster vehicleMaster = new VehicleMaster();
vehicleMaster.vm_Vehicle_Id = Convert.ToInt32(dt.Rows[i]["vm_Vehicle_Id"]);
vehicleMaster.vm_Vehicle_Number = Convert.ToString(dt.Rows[i]["vm_Vehicle_Number"]);
vehicleMaster.vm_Vehicle_desc = Convert.ToString(dt.Rows[i]["vm_Vehicle_desc"]);
vehicleMaster.vm_Status = Convert.ToBoolean(dt.Rows[i]["vm_Status"]);
// vehicleMaster.vm_user = Convert.ToInt32(dt.Rows[i]["vm_user"]);
vehicleMasters[i] = vehicleMaster;
}
return(vehicleMasters);
}
