public int Update(PermissionsOfUserML permissionsOfUser, String ConnectionString)
{
try
{
int id = 0;
StringBuilder Query = new StringBuilder();
Query.AppendFormat("UPDATE {0} ", TableName);
Query.AppendLine(" SET ");
Query.AppendFormat("idUser = {0}", permissionsOfUser.IdUser);
Query.AppendFormat("idPermission = {0}", permissionsOfUser.IdPermission);
Query.AppendFormat("idUserUpdate = {0}", permissionsOfUser.IdUserUpdate);
Query.AppendLine("dateUpdate = GETDATE()");
Query.AppendFormat("WHERE id={0}", permissionsOfUser.Id);
SqlConnection Conexion = new SqlConnection
{
ConnectionString = ConnectionString
};
Conexion.Open();
SqlCommand cmd2 = new SqlCommand(Query.ToString(), Conexion);
id = cmd2.ExecuteNonQuery();
Conexion.Close();
return(id);
}
catch (Exception ex)
{
throw new Exception(String.Format("{0}.update: {1}", core, ex));
}
}
public int Save(PermissionsOfUserML permissionsOfUser, String ConnectionString)
{
try
{
int id = 0;
StringBuilder Query = new StringBuilder();
Query.AppendFormat("INSERT INTO {0}", TableName);
Query.AppendLine("(idUser,idPermission,_registry,idUserInsert,dateInsert)");
Query.AppendFormat(" VALUES({0},{1},1,{2},GETDATE())", permissionsOfUser.IdUser, permissionsOfUser.IdPermission, permissionsOfUser.IdUserInsert);
SqlConnection Conexion = new SqlConnection
{
ConnectionString = ConnectionString
};
Conexion.Open();
SqlCommand cmd2 = new SqlCommand(Query.ToString(), Conexion);
id = cmd2.ExecuteNonQuery();
Conexion.Close();
return(id);
}
catch (Exception ex)
{
throw new Exception(String.Format("{0}.save : {1}", core, ex));
}
}
public int Delete(PermissionsOfUserML PermissionsOfUser)
{
try
{
return(PermissionsOfUserDAL.Delete(PermissionsOfUser, ConnectionStrings));
}
catch (Exception ex)
{
throw new Exception(String.Format("{0}.Delete: {1}", core, ex));
}
}
public int Save(PermissionsOfUserML PermissionsOfUser)
{
try
{
if (PermissionsOfUser.Id == 0)
{
return(PermissionsOfUserDAL.Save(PermissionsOfUser, ConnectionStrings));
}
else
{
return(PermissionsOfUserDAL.Update(PermissionsOfUser, ConnectionStrings));
}
}
catch (Exception ex)
{
throw new Exception(String.Format("{0}.Save: {1}", core, ex));
}
}
