/// <summary>
/// Preenche model generico
/// </summary>
/// <param name="sql">Comando SELECT</param>
/// <param name="forceNoLock">Força comando NOLOCK</param>
/// <returns>Model generico preenchido</returns>
public GenericModel FillGenericModel(string sql, bool forceNoLock)
{
GenericModel genericModel = null;
// SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED tem o mesmo efeito do WITH (NOLOCK)
if (forceNoLock)
{
sql = " SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED " + sql;
}
// Lê os dados em um Recordset
Recordset rs = (Recordset)SBOApp.Company.GetBusinessObject(BoObjectTypes.BoRecordset);
sql = SBOApp.TranslateToHana(sql);
rs.DoQuery(sql);
// Lê os dados e insere no model
if (rs.RecordCount > 0)
{
genericModel = new GenericModel();
genericModel.Fields = new Dictionary <string, object>();
for (int i = 0; i < rs.Fields.Count; i++)
{
genericModel.Fields.Add(rs.Fields.Item(i).Name, rs.Fields.Item(i).Value);
}
}
Marshal.ReleaseComObject(rs);
rs = null;
GC.Collect();
return(genericModel);
}
public async Task <GenericModel <AuthorDataModel> > GetFilteredAuthorsAsync(BaseFilterModel filter)
{
var authors = _context.Authors
.Where(x => x.IsRemoved == false)
.Where(x => x.AuthorInPrintingEditions.Select(z => z.AuthorId == x.Id).FirstOrDefault())
.Include(x => x.AuthorInPrintingEditions)
.ThenInclude(x => x.PrintingEdition);
Expression <Func <Author, object> > predicate = x => x.Id;
if (filter.SortType == Enums.SortType.Name)
{
predicate = x => x.Name;
}
var responseModel = new GenericModel <AuthorDataModel>
{
CollectionCount = authors.Count()
};
var authorsPage = await PaginationAsync(filter, predicate, authors);
var result = authorsPage.Select(x => new AuthorDataModel
{
Id = x.Id,
Name = x.Name,
PrintingEditionTitles = x.AuthorInPrintingEditions
.Select(z => z.PrintingEdition.Title).ToArray()
});
responseModel.Collection = result;
return(responseModel);
}
// GET: PortalPatients
public ActionResult Index(
string firstName = "",
string lastName = "",
int page = 1,
int itemsPerPage = 10)
{
var viewModel = new GenericModel <PortalPatientModel>();
viewModel.Criteria.Add("FirstName", firstName);
viewModel.Criteria.Add("LastName", lastName);
viewModel.Criteria.Add("CriteriaID", "");
try
{
viewModel.SearchResults = PortalPatientProvider.Search(Helpers.GetAuthenticator(), firstName, lastName);
viewModel.Header = Resources.ResultsHeader;
viewModel.ListEmptyMessage = viewModel.SearchResults != null && viewModel.SearchResults.Rows.Count() > 0 ? string.Empty : Resources.ListEmptyMessage;
}
catch (Exception ex)
{
viewModel.ErrorMessage = ex.GetBaseException().Message;
}
return(View("Index", viewModel));
}
public void CreateUserTable(string UserTableName, string UserTableDesc, SAPbobsCOM.BoUTBTableType UserTableType)
{
FindColumns = new GenericModel();
FindColumns.Fields = new Dictionary <string, object>();
Log.AppendLine();
Log.AppendLine(UserTableName);
Log.AppendFormat("Criação/Atualização da tabela de usuário {0}: ", UserTableName);
SAPbobsCOM.UserTablesMD oUserTableMD = (SAPbobsCOM.UserTablesMD)SBOApp.Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oUserTables);
// Remove a arroba do usertable Name
UserTableName = UserTableName.Replace("@", "");
bool bUpdate = oUserTableMD.GetByKey(UserTableName);
oUserTableMD.TableName = UserTableName;
oUserTableMD.TableDescription = UserTableDesc;
oUserTableMD.TableType = UserTableType;
if (bUpdate)
{
//CodErro = oUserTableMD.Update();
CodErro = 0;
}
else
{
CodErro = oUserTableMD.Add();
}
this.ValidateAction();
Marshal.ReleaseComObject(oUserTableMD);
oUserTableMD = null;
}
// POST: Users/Get/5
public ActionResult Get(string id)
{
var viewModel = new GenericModel <UserModel>();
viewModel.Header = Resources.ResultsHeader;
viewModel.Criteria.Add("Active", "");
viewModel.Criteria.Add("Username", "");
viewModel.Criteria.Add("FirstName", "");
viewModel.Criteria.Add("LastName", "");
try
{
var data = UserProvider.Get(Helpers.GetAuthenticator(), id);
viewModel.Data = data;
viewModel.Header = Resources.ResultsHeader;
viewModel.ErrorMessage = data != null ? string.Empty : string.Format(Resources.DataNotFound, id);
}
catch (Exception ex)
{
viewModel.ErrorMessage = ex.GetBaseException().Message;
}
return(View("Index", viewModel));
}
// GET: PatientCommunications/Create
public ActionResult Index(DateTime?utcCreationDate1 = null, DateTime?utcCreationDate2 = null, bool?alreadySent = null, string patientCriteriaId = "", string appointmentCriteriaId = "")
{
var betweenOperador = "between";
utcCreationDate1 = utcCreationDate1 ?? DateTime.MinValue;
utcCreationDate2 = utcCreationDate2 ?? DateTime.MaxValue;
var viewModel = new GenericModel <PatientCommunicationModel>();
viewModel.Criteria.Add("AlreadySent", alreadySent.ToString());
viewModel.Criteria.Add("UtcCreationDate1", utcCreationDate1.ToString());
viewModel.Criteria.Add("UtcCreationDate2", utcCreationDate2.ToString());
viewModel.Criteria.Add("PatientCriteriaId", patientCriteriaId);
viewModel.Criteria.Add("AppointmentCriteriaId", appointmentCriteriaId);
try
{
viewModel.SearchResults = PatientCommunicationProvider.Search(Helpers.GetAuthenticator(), alreadySent, betweenOperador, utcCreationDate1, utcCreationDate2, patientCriteriaId, appointmentCriteriaId);
viewModel.Header = Resources.ResultsHeader;
viewModel.ListEmptyMessage = viewModel.SearchResults != null && viewModel.SearchResults.Rows.Count() > 0 ? string.Empty : Resources.ListEmptyMessage;
}
catch (Exception ex)
{
viewModel.ErrorMessage = ex.GetBaseException().Message;
}
return(View("Index", viewModel));
}
public GenericModel ToGenericModel()
{
var model = new GenericModel();
var verts = GetVertexData();
int indexOffset = 0;
int vertexOffset = 0;
foreach (var m in Mesh.SubMesh)
{
var mesh = new GenericMesh();
mesh.Name = m.FirstVertex + "_Mesh";
model.Meshes.Add(mesh);
for (int f = 0; f < m.IndexCount; f++)
{
mesh.Triangles.Add(Mesh.IndexBuffer[indexOffset + f]);
}
for (int v = 0; v < m.VertexCount; v++)
{
mesh.Vertices.Add(verts[v + vertexOffset]);
}
indexOffset += m.IndexCount;
vertexOffset += m.VertexCount;
}
return(model);
}
/// <summary>
/// Mapping datatable data with our model('GenericModel')
/// </summary>
/// <param name="dataTable"></param>
/// <param name="response">Add properties to list</param>
public static void ToModel(this DataTable dataTable, Response <List <GenericModel> > response)
{
foreach (DataRow row in dataTable.Rows)
{
var model = new GenericModel();
foreach (DataColumn column in dataTable.Columns)
{
if (StringCompare(column.ColumnName, PropertyName.TransactionId.ToString()))
{
model.TransactionId = row[column].ToString();
}
else if (StringCompare(column.ColumnName, PropertyName.TransactionAccount.ToString()))
{
model.TransactionAccount = row[column].ToString();
}
else if (StringCompare(column.ColumnName, PropertyName.TransactionType.ToString()))
{
model.TransactionType = row[column].ToString();
}
else if (StringCompare(column.ColumnName, PropertyName.TransactionAmount.ToString()))
{
model.TransactionAmount = row[column].ToString();
}
}
response.Value.Add(model);
}
}
public GenericViewModel GetDistrictBlockVilage(int id, char type)
{
DataSet districtBlockVilage = _Apdal.GetDistrictBlockVilage(id, type);
GenericViewModel model = new GenericViewModel();
if ((districtBlockVilage != null))
{
if (districtBlockVilage.Tables[0].Rows.Count <= 0)
{
return(model);
}
List <GenericModel> list = new List <GenericModel>();
for (int i = 0; i < districtBlockVilage.Tables[0].Rows.Count; i++)
{
GenericModel item = new GenericModel
{
Id = Convert.ToInt32(districtBlockVilage.Tables[0].Rows[i]["Id"].ToString()),
Name = districtBlockVilage.Tables[0].Rows[i]["Name"].ToString()
};
list.Add(item);
}
model.List = list;
}
return(model);
}
// GET: ServiceTypeDurations/Edit/5
public ActionResult Get(string id)
{
var viewModel = new GenericModel <ServiceTypeDurationModel>();
Guid patientServiceTypeId;
if (!Guid.TryParse(id, out patientServiceTypeId))
{
viewModel.ResultMessage = string.Empty;
viewModel.ErrorMessage = "Please provide a valid ID.";
return(View("Index", viewModel));
}
try
{
var data = ServiceTypeDurationProvider.Get(Helpers.GetAuthenticator(), patientServiceTypeId);
viewModel.Data = data;
viewModel.Header = Resources.ResultsHeader;
viewModel.ErrorMessage = data != null ? string.Empty : string.Format(Resources.DataNotFound, patientServiceTypeId.ToString());
}
catch (Exception ex)
{
viewModel.ErrorMessage = ex.GetBaseException().Message;
}
return(View("Index", viewModel));
}
public GenericModel ToGenericModel()
{
var model = new GenericModel();
model.Skeleton = Skeleton;
return(model);
}
static void Main(string[] args)
{
dynamic x = new GenericModel();
x.First = "Robert";
x.Last = " Pasta";
Console.Write(x.First + x.Last);
}
// GET: OneOffMessages/Create
public ActionResult Index()
{
var viewModel = new GenericModel <OneOffMessageModel>
{
Header = Resources.ResultsHeader
};
return(View(viewModel));
}
// GET: Allergies/Create
public ActionResult Index()
{
var viewModel = new GenericModel <HealthReviewModel>
{
Header = Resources.ResultsHeader
};
return(View(viewModel));
}
// GET: ExamFieldMappings/Create
public ActionResult Index()
{
var viewModel = new GenericModel <ExamFieldMappingModel>
{
Header = Resources.ResultsHeader
};
return(View(viewModel));
}
public ActionResult Index()
{
var viewModel = new GenericModel <GlobalPortal.Api.Models.Forms.OpenFormModel>
{
Header = Resources.ResultsHeader
};
return(View(viewModel));
}
// GET: ServiceTypeDurations/Create
public ActionResult Index()
{
var viewModel = new GenericModel <ServiceTypeDurationModel>
{
Header = Resources.ResultsHeader
};
return(View(viewModel));
}
protected override object CreateModel(ControllerContext controllerContext, ModelBindingContext bindingContext, Type modelType)
{
GenericModel model = CreateGenricModel(controllerContext, bindingContext);
//this is basically a factory that creates the correct IDataItem
// given the newly hydrated GenericModel. It doesn't really apply
// for the given question/answer so I left it out.
return(CreateDataItem(model));
}
public ActionResult Index()
{
var viewModel = new GenericModel <AppointmentAllowedTimeInAdvanceModel>
{
Header = Resources.ResultsHeader
};
return(View(viewModel));
}
// GET: Allergies/Create
public ActionResult Index()
{
var viewModel = new GenericModel <SocialHistoryDrugModel>
{
Header = Resources.ResultsHeader
};
return(View(viewModel));
}
// GET: FamilyRelationships/Create
public ActionResult Index()
{
var viewModel = new GenericModel <FamilyRelationshipModel>
{
Header = Resources.ResultsHeader
};
return(View(viewModel));
}
public virtual IActionResult Edit(GenericModel model)
{
var product = _productService.GetProductById(model.Id);
_genericAttributeService.SaveAttribute <bool>(product, "ExcludeGoogleFeed", model.ExcludeGoogleFeed);
_genericAttributeService.SaveAttribute <string>(product, "Color", model.Color);
return(View(model));
}
// GET: DoctorAvailabilitySlots/Create
public ActionResult Index()
{
var viewModel = new GenericModel <DoctorAvailabilitySlotModel>
{
Header = Resources.ResultsHeader
};
viewModel.Data.DoctorAvailabilityDates.Add(new DoctorAvailabilitySlotModel.DoctorAvailabilityDate());
return(View(viewModel));
}
public void RenderBitmaps()
{
var visual = new DrawingVisual();
using (var c = visual.RenderOpen())
{
c.PushClip(new RectangleGeometry(_rect));
c.DrawRectangle(new SolidColorBrush(Color.FromArgb(0, 0, 0, 0)), null, _rect);
if (MouseModel != null)
{
MouseModel.CloseDrawingContext();
c.DrawRectangle(new VisualBrush(MouseModel), new Pen(), MouseModel.RelativeRect);
}
if (HeadsetModel != null)
{
HeadsetModel.CloseDrawingContext();
c.DrawRectangle(new VisualBrush(HeadsetModel), new Pen(), HeadsetModel.RelativeRect);
}
if (GenericModel != null)
{
GenericModel.CloseDrawingContext();
c.DrawRectangle(new VisualBrush(GenericModel), new Pen(), GenericModel.RelativeRect);
}
if (MousematModel != null)
{
MousematModel.CloseDrawingContext();
c.DrawRectangle(new VisualBrush(MousematModel), new Pen(), MousematModel.RelativeRect);
}
KeyboardModel.CloseDrawingContext();
c.DrawRectangle(new VisualBrush(KeyboardModel), new Pen(), KeyboardModel.RelativeRect);
c.Pop();
}
var frameBitmap = ImageUtilities.DrawingVisualToBitmap(visual, _rect);
if (MouseModel != null)
{
MouseBitmap = MouseModel.GetBitmapFromFrame(frameBitmap);
}
if (HeadsetModel != null)
{
HeadsetBitmap = HeadsetModel.GetBitmapFromFrame(frameBitmap);
}
if (GenericModel != null)
{
GenericBitmap = GenericModel.GetBitmapFromFrame(frameBitmap);
}
if (MousematModel != null)
{
MousematBitmap = MousematModel.GetBitmapFromFrame(frameBitmap);
}
KeyboardBitmap = KeyboardModel.GetBitmapFromFrame(frameBitmap);
}
public void SetModel(GenericModel model)
{
if (!_models.Exists(x => x.Type == model.Type))
{
_models.Add(model);
}
else
{
Debug.LogError("Model type already exists " + model);
}
}
// GET: Home
public ActionResult Index()
{
var model = new GenericModel
{
Now = DateTime.Now,
IsValid = true,
Name = "Corn",
Number = 314
};
return(View(model));
}
public GenericModel ToGenericModel()
{
var model = new GenericModel();
model.Skeleton = skeleton;
var mesh = new GenericMesh();
for (int i = 0; i < PositionBuffer.Length; i++)
{
var vertex = new GenericVertex()
{
Pos = PositionBuffer[i].Xyz
};
if (UV0Buffer.Length == PositionBuffer.Length)
{
vertex.UV0 = UV0Buffer[i];
}
if (UV1Buffer.Length == PositionBuffer.Length)
{
vertex.UV1 = UV1Buffer[i];
}
if (UV2Buffer.Length == PositionBuffer.Length)
{
vertex.UV2 = UV2Buffer[i];
}
mesh.Vertices.Add(vertex);
}
List <short> tris = new List <short>();
tris.AddRange(IndexBuffer);
TriangleConverter.StripToList(tris, out tris);
short max = 0;
foreach (var t in tris)
{
if (t > mesh.VertexCount)
{
break;
}
max = Math.Max(max, t);
mesh.Triangles.Add((uint)t);
}
Console.WriteLine(max.ToString("X") + " " + mesh.VertexCount.ToString("X"));
model.Meshes.Add(mesh);
return(model);
}
public ActionResult Send(GenericModel <FamilyHistoryModel> viewModel)
{
try
{
var success = FamilyHistoryProvider.Save(Helpers.GetAuthenticator(), viewModel.Data);
viewModel.ResultMessage = !success ? Resources.UnsuccesfullySaved : Resources.SuccesfullySaved;
}
catch (Exception ex)
{
viewModel.ErrorMessage = ex.GetBaseException().Message;
}
return(View("Index", viewModel));
}
public void WorkWithGenerics()
{
var manifest = BehaviourManifest.CreateFromAppDomain(AppDomain.CurrentDomain);
var generic = new GenericModel()
{
Data = JObject.FromObject(new ChildModel()),
Type = "ChildModel"
};
var editorSession = new EditorSession(manifest, generic, new JsonSerializer());
DrawTree(editorSession.Root);
}
/// <summary>
///
/// </summary>
/// <param name="filePath"></param>
/// <param name="m"></param>
/// <returns></returns>
public bool ExportModel(string filePath, GenericModel m)
{
var ext = System.IO.Path.GetExtension(filePath).ToLower();
foreach (var v in ModelExporters)
{
if (v.Extension().Equals(ext))
{
v.Export(filePath, m);
return(true);
}
}
return(false);
}
public static void Draw(GenericModel model, Matrix view, Matrix projection)
{
new ModelDrawer(model, view, projection).Draw();
}
private ModelDrawer(GenericModel model, Matrix view, Matrix projection)
: base(view, projection)
{
Model = model;
}
