// Update Employee
public HttpResponseMessage Put(Usersdata user)
{
string OutMessage = string.Empty;
List <userinfo> emplist = new List <userinfo>();
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
using (callcenterEntities db = new callcenterEntities())
{
try
{
ObjectParameter Output = new ObjectParameter("responseMessage", typeof(string));
var users = db.uspAddUser(user.LoginName, Convert.ToString(user.PasswordHash), user.UserName, user.UserEmail, user.IsAdmin, user.IsActive, user.CanEdit, user.CanFilter, user.CanNavigate, Output);
OutMessage = Convert.ToString(Output.Value);
emplist = db.userinfoes.ToList();
}
catch (DbUpdateConcurrencyException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
}
return(Request.CreateResponse(HttpStatusCode.OK, new { emplist, responsemessage = OutMessage }));
}
// GET api/<controller>
public List <Usersdata> Get()
{
List <Usersdata> emplist = new List <Usersdata>();
using (callcenterEntities db = new callcenterEntities())
{
var results = db.userinfoes.ToList();
/*var results = db.GetAllUsers(0, "").ToList();
* //var results = db.sp_InsUpdDelEmployee(0, "", "", "", "", "", "Get").ToList(); */
foreach (var result in results)
{
var employee = new Usersdata()
{
UserId = result.UserId,
LoginName = result.LoginName,
UserEmail = result.UserEmail,
UserName = result.UserName,
IsActive = result.IsActive,
IsAdmin = result.IsAdmin,
CanEdit = result.CanEdit,
CanFilter = result.CanFilter,
CanNavigate = result.CanNavigate
};
emplist.Add(employee);
}
return(emplist);
}
}
// Insert Employee
public HttpResponseMessage Post(Usersdata user)
{
string OutMessage = string.Empty;
if (ModelState.IsValid)
{
using (callcenterEntities db = new callcenterEntities())
{
ObjectParameter Output = new ObjectParameter("responseMessage", typeof(string));
//string mssage = string.Empty;
var objresults = db.uspAddUser(user.LoginName, Convert.ToString(user.PasswordHash), user.UserName, user.UserEmail, user.IsAdmin, user.IsActive, user.CanEdit, user.CanFilter, user.CanNavigate, Output);
var emplist = db.userinfoes.ToList();
OutMessage = Convert.ToString(Output.Value);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, new { emplist, responsemessage = OutMessage });
return(response);
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public ActionResult Login(LoginViewModel model, string returnUrl)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (callcenterEntities db = new callcenterEntities())
{
ObjectParameter Output = new ObjectParameter("responseMessage", typeof(string));
db.uspValidateUser(model.Username, model.Password, Output);
if (Convert.ToString(Output.Value).Contains("Success"))
{
var validuser = db.userinfoes.FirstOrDefault(i => i.LoginName == model.Username);
Session["UserID"] = validuser.UserId;
Session["LoginName"] = validuser.LoginName;
Session["UserName"] = validuser.UserName;
Session["UserEmail"] = validuser.UserEmail;
if (validuser.IsAdmin)
{
Session["IsAdmin"] = true;
}
else
{
Session["IsAdmin"] = false;
}
return(RedirectToAction("Index", "Home"));
}
else
{
ModelState.AddModelError("", Convert.ToString(Output.Value));
return(View(model));
}
}
// This doesn't count login failures towards account lockout
// To enable password failures to trigger account lockout, change to shouldLockout: true
//var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout: false);
//switch (result)
//{
// case SignInStatus.Success:
// return RedirectToLocal(returnUrl);
// case SignInStatus.LockedOut:
// return View("Lockout");
// case SignInStatus.RequiresVerification:
// return RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe });
// case SignInStatus.Failure:
// default:
// ModelState.AddModelError("", "Invalid login attempt.");
// return View(model);
//}
}
// GET api/<controller>/5
public userinfo Get(int id)
{
using (callcenterEntities db = new callcenterEntities())
{
userinfo employee = db.userinfoes.Find(id);
// employee.PasswordHash = "";
if (employee == null)
{
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound));
}
return(employee);
}
}
public HttpResponseMessage DeleteMethod(int Id)
{
string OutMessage = string.Empty;
using (callcenterEntities db = new callcenterEntities())
{
List <userinfo> emplist = new List <userinfo>();
try
{
ObjectParameter Output = new ObjectParameter("responseMessage", typeof(string));
string plogin = db.userinfoes.Find(Id).LoginName;
db.uspDeleteUser(plogin, Output);
OutMessage = Convert.ToString(Output.Value);
// emplist = db.userinfoes.ToList();
emplist = db.userinfoes.ToList();
emplist.FirstOrDefault(i => i.UserId == Id).IsActive = false;
}
catch (DbUpdateConcurrencyException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK, new { emplist, responsemessage = OutMessage }));
}
}
public OperacionesService(callcenterEntities pDb) : base(pDb)
{
this.db = pDb;
reply = new ReplyViewModel();
}
public SeguimientosService(callcenterEntities pDb) : base(pDb)
{
this.db = pDb;
reply = new ReplyViewModel();
}
public AgendaService(callcenterEntities pDb) : base(pDb)
{
this.db = pDb;
reply = new ReplyViewModel();
}
public HomeService(callcenterEntities pDb) : base(pDb)
{
this.db = pDb;
this.reply = new ReplyViewModel();
}
public PersonasService(callcenterEntities pDb)
{
this.db = pDb;
}
public Call(callcenterEntities pdb) : base(pdb)
{
this.db = pdb;
}
public async Task <EmbedConfig> EmbedReport(string username, string roles)
{
var result = new EmbedConfig();
try
{
result = new EmbedConfig {
Username = username, Roles = roles
};
var error = GetWebConfigErrors();
if (error != null)
{
result.ErrorMessage = error;
// return View(result);
return(result);
}
// Create a user password cradentials.
var credential = new UserPasswordCredential(Username, Password);
// Authenticate using created credentials
var authenticationContext = new AuthenticationContext(AuthorityUrl);
var authenticationResult = await authenticationContext.AcquireTokenAsync(ResourceUrl, ApplicationId, credential);
if (authenticationResult == null)
{
result.ErrorMessage = "Authentication Failed.";
// return View(result);
return(result);
}
var tokenCredentials = new TokenCredentials(authenticationResult.AccessToken, "Bearer");
// Create a Power BI Client object. It will be used to call Power BI APIs.
using (var client = new PowerBIClient(new Uri(ApiUrl), tokenCredentials))
{
// Get a list of reports.
var reports = await client.Reports.GetReportsInGroupAsync(WorkspaceId);
// No reports retrieved for the given workspace.
if (reports.Value.Count() == 0)
{
result.ErrorMessage = "No reports were found in the workspace";
// return View(result);
return(result);
}
Report report;
if (string.IsNullOrWhiteSpace(ReportId))
{
// Get the first report in the workspace.
report = reports.Value.FirstOrDefault();
}
else
{
report = reports.Value.FirstOrDefault(r => r.Id == ReportId);
}
if (report == null)
{
result.ErrorMessage = "No report with the given ID was found in the workspace. Make sure ReportId is valid.";
// return View(result);
return(result);
}
var datasets = await client.Datasets.GetDatasetByIdInGroupAsync(WorkspaceId, report.DatasetId);
result.IsEffectiveIdentityRequired = datasets.IsEffectiveIdentityRequired;
result.IsEffectiveIdentityRolesRequired = datasets.IsEffectiveIdentityRolesRequired;
GenerateTokenRequest generateTokenRequestParameters;
// This is how you create embed token with effective identities
if (!string.IsNullOrWhiteSpace(username))
{
var rls = new EffectiveIdentity(username, new List <string> {
report.DatasetId
});
if (!string.IsNullOrWhiteSpace(roles))
{
var rolesList = new List <string>();
rolesList.AddRange(roles.Split(','));
rls.Roles = rolesList;
}
// Generate Embed Token with effective identities.
generateTokenRequestParameters = new GenerateTokenRequest(accessLevel: "view", identities: new List <EffectiveIdentity> {
rls
});
}
else
{
// Generate Embed Token for reports without effective identities.
generateTokenRequestParameters = new GenerateTokenRequest(accessLevel: "view");
}
var tokenResponse = await client.Reports.GenerateTokenInGroupAsync(WorkspaceId, report.Id, generateTokenRequestParameters);
if (tokenResponse == null)
{
result.ErrorMessage = "Failed to generate embed token.";
// return View(result);
return(result);
}
if (Session["UserID"] != null)
{
using (callcenterEntities db = new callcenterEntities())
{
int userid = Convert.ToInt32(Session["UserID"]);
var validuser = db.userinfoes.FirstOrDefault(i => i.UserId == userid);
result.CanEdit = validuser.CanEdit;
result.CanFilter = validuser.CanFilter;
result.CanNavigate = validuser.CanNavigate;
}
}
// Generate Embed Configuration.
result.EmbedToken = tokenResponse;
result.EmbedUrl = report.EmbedUrl;
result.Id = report.Id;
// return View(result);
return(result);
}
}
catch (HttpOperationException exc)
{
result.ErrorMessage = string.Format("Status: {0} ({1})\r\nResponse: {2}\r\nRequestId: {3}", exc.Response.StatusCode, (int)exc.Response.StatusCode, exc.Response.Content, exc.Response.Headers["RequestId"].FirstOrDefault());
}
catch (Exception exc)
{
result.ErrorMessage = exc.ToString();
}
// return View(result);
return(result);
}
// Prevent Memory Leak
protected override void Dispose(bool disposing)
{
using (callcenterEntities db = new callcenterEntities())
db.Dispose();
base.Dispose(disposing);
}
public SecurityLayer(callcenterEntities pdb)
{
this.db = pdb;
}
public UsuarioService(callcenterEntities pDb)
{
this.db = pDb;
}
