public BioProfile Read(long id)
{
const string sql = "SELECT Id, ObjectId, CreatedAt, ModifiedAt, DeletedAt FROM BioProfile WHERE Id=@Id";
BioProfile entity = null;
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
using (var command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@Id", id);
var reader = command.ExecuteReader(CommandBehavior.SingleResult);
while (reader.Read())
{
entity = new BioProfile()
{
Id = (System.Int64)reader["Id"],
ObjectId = (System.Guid)reader["ObjectId"],
CreatedAt = (System.DateTime)reader["CreatedAt"],
ModifiedAt = (System.DateTime)reader["ModifiedAt"],
DeletedAt = (System.DateTime?)reader["DeletedAt"],
};
}
}
}
return(entity);
}
//for loading Tama's Bio
public void TamaBio()
{
Debug.Log("Clicked Tama");
currentlyViewBio = Tama;
nameTag.transform.Find("Text").gameObject.GetComponent <Text>().text = Tama.getFullName();
displayBioInformation(Tama);
}
public void displayBioInformation(BioProfile sourceBio)
{
BioFile temp = sourceBio.getSpecificBio(sourceBio.getCurrentViewIndex());
if (temp.isLocked())
{
setTextAreaToLockedPlaceHolder();
}
else
{
setTextArea(temp.getBioTitle(), temp.getBioContents());
}
}
public bool Insert(BioProfile entity)
{
const string sql = "INSERT INTO BioProfile ( Id, ObjectId, CreatedAt, ModifiedAt, DeletedAt ) VALUES ( @Id, @ObjectId, @CreatedAt, @ModifiedAt, @DeletedAt )";
long rows;
using (var connection = new SqlConnection(_connectionString))
{
using (var command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@Id", entity.Id);
command.Parameters.AddWithValue("@ObjectId", entity.ObjectId);
command.Parameters.AddWithValue("@CreatedAt", entity.CreatedAt);
command.Parameters.AddWithValue("@ModifiedAt", entity.ModifiedAt);
command.Parameters.AddWithValue("@DeletedAt", entity.DeletedAt);
rows = command.ExecuteNonQuery();
}
}
return(rows > 0);
}
public bool Update(BioProfile entity)
{
return(false);
}
//for loading Neru's Bio
public void NeruBio()
{
currentlyViewBio = Neru;
nameTag.transform.Find("Text").gameObject.GetComponent <Text>().text = Neru.getFullName();
displayBioInformation(Neru);
}
//for loading Elliot's Bio
public void ElliotBio()
{
currentlyViewBio = Elliot;
nameTag.transform.Find("Text").gameObject.GetComponent <Text>().text = Elliot.getFullName();
displayBioInformation(Elliot);
}
//for loading Akira's Bio
public void AkiraBio()
{
currentlyViewBio = Akira;
nameTag.transform.Find("Text").gameObject.GetComponent <Text>().text = Akira.getFullName();
displayBioInformation(Akira);
}
