private void AssignDataObjectToEntity(tbl_Categories dbCategory, ref Category entCategory)
{
entCategory.IdCategory = dbCategory.IdCategory;
entCategory.Name = dbCategory.Name;
entCategory.Description = dbCategory.Description;
entCategory.AssignedTo = new UserInfo()
{
IdUser = dbCategory.tbl_Users.IdUser,
UserCompleteName = dbCategory.tbl_Users.FirstName + ' ' + dbCategory.tbl_Users.LastName,
CreatedOn = dbCategory.tbl_Users.CreatedOn,
Email = dbCategory.tbl_Users.Email,
FirstName = dbCategory.tbl_Users.FirstName,
LastName = dbCategory.tbl_Users.LastName,
HashCode = dbCategory.tbl_Users.HashCode,
ModifiedOn = dbCategory.tbl_Users.ModifiedOn,
Password = dbCategory.tbl_Users.Password,
UserName = dbCategory.tbl_Users.UserName,
Company = new Company()
{
IdCompany = dbCategory.tbl_Users.tbl_Companies.IdCompany,
Name = dbCategory.tbl_Users.tbl_Companies.Name,
Description = dbCategory.tbl_Users.tbl_Companies.Description,
EntStatus = new Status() { IdStatus = dbCategory.tbl_Users.tbl_Companies.tbl_Status.IdStatus, Name = dbCategory.tbl_Users.tbl_Companies.tbl_Status.Name }
},
EntRole = new RoleInfo()
{
IdRole = dbCategory.tbl_Users.tbl_Roles.IdRole,
Description = dbCategory.tbl_Users.tbl_Roles.Description,
Name = dbCategory.tbl_Users.tbl_Roles.Name,
RoleCode = dbCategory.tbl_Users.tbl_Roles.RoleCode,
EntStatus = new Status()
{
IdStatus = dbCategory.tbl_Users.tbl_Roles.tbl_Status.IdStatus,
Name = dbCategory.tbl_Users.tbl_Roles.tbl_Status.Name
}
},
EntStatus = new Status() { IdStatus = dbCategory.tbl_Users.tbl_Status.IdStatus, Name = dbCategory.tbl_Users.tbl_Status.Name }
};
entCategory.AlternativeMail = dbCategory.AlternativeMail;
entCategory.EntStatus = new Status() { IdStatus = dbCategory.tbl_Status.IdStatus,Name=dbCategory.tbl_Status.Name};
entCategory.DefaultMail = entCategory.AssignedTo.Email;
}
partial void Deletetbl_Categories(tbl_Categories instance);
partial void Updatetbl_Categories(tbl_Categories instance);
partial void Inserttbl_Categories(tbl_Categories instance);
private void detach_tbl_Categories(tbl_Categories entity)
{
this.SendPropertyChanging();
entity.tbl_Users = null;
}
private void attach_tbl_Categories(tbl_Categories entity)
{
this.SendPropertyChanging();
entity.tbl_Status = this;
}
//MySQLConnector mscConnector;
//CategoryQueries cqQuery;
//UtilsService Utilities;
//private void InitializeControllers()
//{
// mscConnector = new MySQLConnector();
// cqQuery = new CategoryQueries();
// Utilities = new UtilsService();
//}
private bool Insert(Category entCategory)
{
TCRepositoryDataContext context = DataBaseUtils.GetContext();
try
{
tbl_Categories dbCategory = new tbl_Categories()
{
Name = entCategory.Name,
Description = entCategory.Description,
AlternativeMail = entCategory.AlternativeMail,
IdUserAssigned = entCategory.AssignedTo.IdUser,
IdStatus = entCategory.EntStatus.IdStatus
};
context.tbl_Categories.InsertOnSubmit(dbCategory);
context.SubmitChanges();
return true;
}
catch
{}
return false;
}