/// <summary>
///
/// </summary>
/// <param name="userName"></param>
/// <param name="roleName"></param>
/// <returns></returns>
public override bool IsUserInRole(string userName, string roleName)
{
if (String.IsNullOrEmpty(userName))
{
throw new ArgumentException("Value cannot be null or empty.", "userName");
}
using (PortalDBContext db = new PortalDBContext())
{
Login login = db.Logins.FirstOrDefault(x => x.UserId.ToUpper().Equals(userName.ToUpper()));
if (login == null)
{
return(false);
}
EmployeeRole employeeRole = login.Employee.EmployeeRoles.FirstOrDefault(x => x.Role.Name.Equals(roleName));
if (employeeRole != null)
{
return(true);
}
else
{
return(false);
}
}
}
public async Task <IHttpActionResult> SavePortalPerson(int messagePortalPersonId)
{
try
{
string url = this.PortalDBContext.GetMessageGatewaysSync().FirstOrDefault().GatewayURL;
PortalReturnInfo portalPerson = PortalDBContext.GetPortalByIdSync(messagePortalPersonId);
bool smsResult = await RestAPIHelper.CallAPI(url, portalPerson.Mobile, portalPerson.MessageText);
PortalPersonInfo personInfo = new PortalPersonInfo
{
PersonId = portalPerson.PersonId,
MessagePortalGroupId = portalPerson.MessagePortalGroupId,
Username = username
};
personInfo.IsSent = smsResult;
var result = await this.PortalDBContext.UpdatePortalPerson(personInfo);
return(Ok(result));
}
catch (Exception ex)
{
throw ex;
}
//return InternalServerError();
}
/// <summary>
///
/// </summary>
/// <param name="username"></param>
/// <param name="oldPassword"></param>
/// <param name="newPassword"></param>
/// <returns></returns>
public DataSet TSWeeklyEmail(string SPName, string EmpId, string Date)
{
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
DataSet retVal = new DataSet();
retVal.Tables.Add(dt);
retVal.Tables.Add(dt1);
using (PortalDBContext db = new PortalDBContext())
{
var entityConn = db.Database.Connection;
var cmd = entityConn.CreateCommand();
cmd.CommandText = SPName;
cmd.Connection.Open();
cmd.Parameters.Add(new SqlParameter("EMPLOYEEID", EmpId));
cmd.Parameters.Add(new SqlParameter("Date", Date));
cmd.CommandType = CommandType.StoredProcedure;
var reader = cmd.ExecuteReader();
retVal.Load(reader, LoadOption.OverwriteChanges, dt, dt1);
cmd.Connection.Close();
}
return(retVal);
}
/// <summary>
/// Validate user information
/// </summary>
/// <param name="userName"></param>
/// <param name="password"></param>
/// <returns></returns>
public override bool ValidateUser(string userName, string password)
{
if (String.IsNullOrEmpty(userName))
{
throw new ArgumentException("Value cannot be null or empty.", "userName");
}
if (String.IsNullOrEmpty(password))
{
throw new ArgumentException("Value cannot be null or empty.", "password");
}
using (PortalDBContext db = new PortalDBContext())
{
//Get the login information by user name
Login login = db.Logins.SingleOrDefault(x => x.UserId.ToUpper().Equals(userName.ToUpper()));
if (login == null)
{
return(false);
}
//Decript password
string decryptedPassword = password;
if (!login.Password.Equals(decryptedPassword))
{
return(false);
}
return(true);
}
}
public async Task <IHttpActionResult> GetMessageGateways(int messageGatewayId)
{
try
{
var data = await PortalDBContext.GetMessageGatewayById(messageGatewayId);
return(Ok(data));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IHttpActionResult> GetMessageGateways(int pageNo, int itemsPerPage, int pagePerDisplay)
{
try
{
var data = await PortalDBContext.GetMessageGateways(pageNo, itemsPerPage, pagePerDisplay);
return(Ok(data));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IHttpActionResult> GetMessageTypes()
{
try
{
var data = await PortalDBContext.GetMessageTypes();
return(Ok(data));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IHttpActionResult> DeletePortal(int[] messagePortalPersons)
{
try
{
var result = await PortalDBContext.DeletePortal(messagePortalPersons, username);
if (result != null)
{
return(Ok(result));
}
return(InternalServerError());
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IHttpActionResult> DeleteMessageGateway(int messageGatewayId)
{
try
{
var result = await PortalDBContext.DeleteMessageGateway(messageGatewayId, username);
if (result != null)
{
return(Ok(result));
}
return(InternalServerError());
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IHttpActionResult> GetPortals(string personName, int groupId, string mobile, byte isSent,
int pageNo, int itemsPerPage, int pagePerDisplay)
{
try
{
if (string.IsNullOrEmpty(personName))
{
personName = "";
}
if (string.IsNullOrEmpty(mobile))
{
mobile = "";
}
var data = await PortalDBContext.GetPortals(personName, groupId, mobile, isSent, pageNo, itemsPerPage, pagePerDisplay);
return(Ok(data));
}
catch (Exception ex)
{
throw ex;
}
}
public override bool ChangePassword(string username, string oldPassword, string newPassword)
{
using (PortalDBContext db = new PortalDBContext())
{
//Get the login information by user name
Login login = db.Logins.SingleOrDefault(x => x.UserId.ToUpper().Equals(username.ToUpper()));
if (login == null)
{
return(false);
}
login.Password = newPassword;
login.Status = (int)LoginStatus.EXISTING;
db.Logins.Attach(login);
db.Entry(login).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
/// <summary>
///
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public override string[] GetRolesForUser(string userName)
{
if (String.IsNullOrEmpty(userName))
{
throw new ArgumentException("Value cannot be null or empty.", "userName");
}
List <string> roles = new List <string>();
using (PortalDBContext db = new PortalDBContext())
{
Login login = db.Logins.FirstOrDefault(x => x.UserId.ToUpper().Equals(userName.ToUpper()));
if (login == null)
{
return(null);
}
login.Employee.EmployeeRoles.ToList().ForEach(x => roles.Add(x.Role.Name));
}
return(roles.ToArray());
}
/// <summary>
///
/// </summary>
/// <param name="requestContext"></param>
protected override void Initialize(RequestContext requestContext)
{
if (taskService == null)
{
taskService = new TaskService();
}
if (MembershipService == null)
{
MembershipService = new MembershipService();
}
if (AuthenticationService == null)
{
AuthenticationService = new FormsAuthenticationService();
}
if (db == null)
{
db = new PortalDBContext();
}
base.Initialize(requestContext);
}
public DbInitializer(PortalDBContext context)
{
_context = context;
}
public UserDAO(PortalDBContext portalDBContext)
{
_portalDBContext = portalDBContext;
}
public TransactionDAO(PortalDBContext customerContext)
{
_customerContext = customerContext;
}
public BaseService()
{
this.db = new PortalDBContext();
}
public TransactionController(PortalDBContext context, ITransactionBL transactionBL)
{
_context = context;
_transactionBL = transactionBL;
}
