public static async Task <_Project> DbToProjectAsync(Project project, ApplicationDbContext context)
{
_Project convertedProject = new _Project();
#region Same property Content Cloning
#region Unneeded
//convertedProject.Id = project.Id;
//convertedProject.Name = project.Name;
//convertedProject.Explanation = project.Explanation;
//convertedProject.GithubLink = project.GithubLink;
//foreach (var property in typeof(Project).GetProperties())
//{
// if (property.GetCustomAttributes(typeof(IgnoreCopy), false).Length > 0) continue;
// var property1 = typeof(_Project).GetProperty(property.Name);
// property1.SetValue(convertedProject, property.GetValue(project));
//}
#endregion
convertedProject = Helper.Copy.Action(project, convertedProject);
#endregion
#region Ids to Project Arrays
List <int> ids = new List <int>();
try
{
foreach (var id in project.PersonIds.Split('-'))
{
try
{
ids.Add(int.Parse(id));
}
catch (Exception) { }
}
}catch (Exception) { }
List <Person> People = new List <Person>();
foreach (var id in ids)
{
Person tempPerson = await context.Person.FindAsync(id);
tempPerson.Password = "******";
People.Add(tempPerson);
}
convertedProject.People = People.ToArray();
#endregion
return(convertedProject);
}
internal static _Project Project()
{
if (_ProjectFunc == null)
{
_ProjectFunc =
(_Project)Marshal.GetDelegateForFunctionPointer(
Torque3D.DllLoadUtils.GetProcAddress(
Torque3D.Torque3DLibHandle,
"fnGuiTSCtrl_project"), typeof(_Project));
}
return(_ProjectFunc);
}
internal static _Project Project()
{
if (_ProjectFunc == null)
{
_ProjectFunc =
(_Project)Marshal.GetDelegateForFunctionPointer(
NativeLibrary.GetExport(
Torque3D.Torque3DLibHandle,
"fnGuiTSCtrl_project"), typeof(_Project));
}
return(_ProjectFunc);
}
public _Project getProject(int id)
{
List <string> test = new List <string>();
List <string> url = new List <string>();
var p = _repo.Projects.Where(x => x.id == id).SingleOrDefault();
if (!string.IsNullOrEmpty(p.images))
{
test = JsonConvert.DeserializeObject <List <string> >(p.images);
url = JsonConvert.DeserializeObject <List <string> >(p._url);
}
_Project proj = new _Project()
{
project = p, images = url
};
return(proj);
}
public List <_Project> GetProject()
{
List <_Project> output = new List <_Project>();
SqlConnection con = new SqlConnection(connectionString);
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "SELECT * FROM tblProject WHERE project_status =1 ";
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
_Project p = new _Project();
p.project_name = Convert.ToString(dr["project_name"]);
p.project_value = Convert.ToString(dr["project_value"]);
output.Add(p);
}
con.Close();
return(output);
}
