partial void Deletetbl_Roles(tbl_Roles instance);
partial void Updatetbl_Roles(tbl_Roles instance);
partial void Inserttbl_Roles(tbl_Roles instance);
private void detach_tbl_Roles(tbl_Roles entity)
{
this.SendPropertyChanging();
entity.tbl_Status = null;
}
private bool InsertRole(RoleInfo entRole)
{
DbTransaction trans = null;
TCRepositoryDataContext context = DataBaseUtils.GetContext();
bool result = false;
try
{
context.Connection.Open();
trans = context.Connection.BeginTransaction();
context.Transaction = trans;
tbl_Roles dbRole = new tbl_Roles()
{
Description = entRole.Description,
IdStatus = entRole.EntStatus.IdStatus,
Name = entRole.Name,
RoleCode = entRole.RoleCode
};
context.tbl_Roles.InsertOnSubmit(dbRole);
context.SubmitChanges();
List<ServicesLibrary.Entities.SiteMap> listSiteMap = entRole.EntListSiteMap;
List<tbl_Roles_SiteMap> dbRolesSiteMap = (from s in listSiteMap
select new tbl_Roles_SiteMap()
{
IdRole = dbRole.IdRole,
IdSiteMap = s.IdSiteMap
}).ToList();
context.tbl_Roles_SiteMap.InsertAllOnSubmit(dbRolesSiteMap);
context.SubmitChanges();
trans.Commit();
result = true;
}
catch (SqlException excs)
{
if (trans != null)
trans.Rollback();
}
catch (Exception exc)
{
if (trans != null)
trans.Rollback();
}
finally
{
if (context.Connection.State == ConnectionState.Open)
context.Connection.Close();
}
return result;
}
private void AssignDataObjectToEntity(tbl_Roles dbRole, ref RoleInfo entRoleInfo)
{
entRoleInfo.IdRole = dbRole.IdRole;
entRoleInfo.Name = dbRole.Name;
entRoleInfo.Description = dbRole.Description;
entRoleInfo.RoleCode = dbRole.RoleCode;
entRoleInfo.EntStatus = new Status { IdStatus = dbRole.tbl_Status.IdStatus, Name = dbRole.tbl_Status.Name };
}