/// <summary>
/// Returns token Expires timespan
/// </summary>
/// <param name="refreshTokenLifeTime"></param>
/// <param name="refreshTokenLifeTimeType"></param>
/// <returns></returns>
private TimeSpan GetExpiresTimeSpan(int?refreshTokenLifeTime, int?refreshTokenLifeTimeType)
{
try
{
TimeSpan timeSpan = TimeSpan.MaxValue;
var gc = CommonDBFunctions.GetGlobalCode(refreshTokenLifeTimeType);
if (gc.CodeName == "Day" && gc.Code == "TOKENLIFETIMEDAY")
{
timeSpan = TimeSpan.FromDays(Convert.ToDouble(refreshTokenLifeTime));
}
else if (gc.CodeName == "Hour" && gc.Code == "TOKENLIFETIMEHOUR")
{
timeSpan = TimeSpan.FromHours(Convert.ToDouble(refreshTokenLifeTime));
}
else if (gc.CodeName == "Minute" && gc.Code == "TOKENLIFETIMEMINUTE")
{
timeSpan = TimeSpan.FromMinutes(Convert.ToDouble(refreshTokenLifeTime));
}
return(timeSpan);
}
catch (Exception ex)
{
Exception excep = new Exception("Exception occured in SimpleAuthorizationServerProvider.GetExpiresTimeSpan method." + ex.Message);
throw excep;
}
}
protected void WriteTrace(TraceRecord record)
{
if (record != null && record.Exception != null)
{
int staffId = 0;
string usercode = string.Empty;
var queryString = record.Request.RequestUri.Query;
if (!String.IsNullOrWhiteSpace(queryString))
{
int.TryParse(System.Web.HttpUtility.ParseQueryString(queryString.Substring(1))["staffId"], out staffId);
usercode = CommonDBFunctions.GetCurrentUser(staffId);
}
else
{
usercode = "MobileApi";
}
var errorMessage = string.Format(
"{0} {1}: Category={2}, Level={3} {4} {5} {6} {7}",
record.Request.Method.ToString(),
record.Request.RequestUri.ToString(),
record.Category,
record.Level,
record.Kind,
record.Operator,
record.Operation,
record.Exception != null ? record.Exception.GetBaseException().Message : !string.IsNullOrEmpty(record.Message) ? record.Message : string.Empty);
_ctx.ssp_SCLogError(errorMessage, record.Exception.StackTrace, "MobileErrorTrace", usercode, DateTime.Now, "");
}
}
public Status InsertUser(UserExtend user)
{
DbParameter[] parameter =
{
DataParameter.GetSqlParam(dbUserEnity.Email.ToString(), SqlDbType.VarChar, 30, user.Email, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.UserName.ToString(), SqlDbType.VarChar, 30, user.UserName, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.Password.ToString(), SqlDbType.VarChar, 30, user.Password, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.FirstName.ToString(), SqlDbType.VarChar, 30, user.FirstName, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.LastName.ToString(), SqlDbType.VarChar, 30, user.LastName, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.Gender.ToString(), SqlDbType.Int, 20, user.Gender, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.DOB.ToString(), SqlDbType.DateTime, 30, user.DOB, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.Status.ToString(), SqlDbType.Int, 10, user.Status, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.SaltKey.ToString(), SqlDbType.VarChar, 6, CommonFunctions.SaltKey(), ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.ActiveGuid.ToString(), SqlDbType.VarChar, 50, Guid.NewGuid().ToString(), ParameterDirection.Input),
DataParameter.GetSqlParam("RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.Output),
};
try
{
return(new Status()
{
StatusId = CommonDBFunctions.ExecuteNonQuery(spUser.spUserInsert.ToString(), parameter), MsgDesc = AppConstant.SuccessMsg
});
}
catch (SqlException ex)
{
throw ex;
}
}
/// <summary>
/// Returns Token Expires Utc
/// </summary>
/// <param name="refreshTokenLifeTime"></param>
/// <param name="refreshTokenLifeTimeType"></param>
/// <param name="currentTime"></param>
/// <returns></returns>
private DateTime GetExpiresUtc(int?refreshTokenLifeTime, int?refreshTokenLifeTimeType, DateTime currentTime)
{
try
{
DateTime dateTime = DateTime.Now;
var gc = CommonDBFunctions.GetGlobalCode(refreshTokenLifeTimeType);
if (gc.CodeName == "Day" && gc.Code == "TOKENLIFETIMEDAY")
{
dateTime = currentTime.AddDays(Convert.ToDouble(refreshTokenLifeTime));
}
else if (gc.CodeName == "Hour" && gc.Code == "TOKENLIFETIMEHOUR")
{
dateTime = currentTime.AddHours(Convert.ToDouble(refreshTokenLifeTime));
}
else if (gc.CodeName == "Minute" && gc.Code == "TOKENLIFETIMEMINUTE")
{
dateTime = currentTime.AddMinutes(Convert.ToDouble(refreshTokenLifeTime));
}
return(dateTime);
}
catch (Exception ex)
{
Exception excep = new Exception("Exception occured in SimpleAuthorizationServerProvider.GetExpiresUtc method." + ex.Message);
throw excep;
}
}
/// <summary>
/// Used to Authenticate With AD
/// </summary>
/// <param name="userName"></param>
/// <param name="password"></param>
/// <returns></returns>
private bool AuthenticateWithActiveDirectory(string userName, string password)
{
try
{
bool authenticated = false;
string domain = _scEntity.Staffs.Where(s => s.UserCode == userName).DefaultIfEmpty(null).Select(s => s.ActiveDirectoryStaff.ActiveDirectoryDomains.DomainName ?? "").FirstOrDefault().ToString();
if (SC.Data.CommonDBFunctions.GetSystemConfigurationKeyValue("ValidateFromWebService").ToUpper() == "Y")
{
SC.Data.SHSADAuthentication.ADAuthenticationService ad = new Data.SHSADAuthentication.ADAuthenticationService();
ad.Credentials = System.Net.CredentialCache.DefaultCredentials;
ad.Url = CommonDBFunctions.GetSystemConfigurationKeyValue("AuthWebServiceURL");
SC.Data.SHSADAuthentication.Authentication a = new Data.SHSADAuthentication.Authentication();
a.TokenKey = CommonDBFunctions.GetSystemConfigurationKeyValue("WebServiceKeyToken");
ad.AuthenticationValue = a;
authenticated = ad.ValidateUser(userName.Trim(), password.Trim(), domain.Trim());
}
else
{
using (PrincipalContext pc = new PrincipalContext(ContextType.Domain, domain))
{
authenticated = pc.ValidateCredentials(userName.Trim(), password.Trim());
}
}
return(authenticated);
}
catch (Exception ex)
{
Exception excep = new Exception("Exception occured in AuthRepository.AuthenticateWithActiveDirectory method." + ex.Message);
throw excep;
}
}
/// <summary>
/// Save MyPreference Screen Data.
/// </summary>
/// <param name="stf"></param>
/// <param name="loggedInUser"></param>
/// <returns></returns>
public async Task <_SCResult <Models.StaffPreferenceModel> > Save(StaffPreferences stf, int loggedInUser)
{
try
{
var _Ce = new _SCResult <Models.StaffPreferenceModel>();
IBriefcaseRepository _repo = new BriefcaseRepositiry(new SCMobile());
List <Difference> differences = new List <Difference>();
bool modified = IsDataModified(stf.StaffPreferenceId, loggedInUser, CommonDBFunctions.GetGlobalCodeId("BRIEFCASETYPE", "MYPREFERENCE"), stf, out differences);
if (modified)
{
var original = _scEntity.StaffPreferences
.Where(s => s.StaffPreferenceId == stf.StaffPreferenceId).FirstOrDefault();
foreach (var difference in differences)
{
string[] changedPprts = difference.PropertyName.Split(new char[] { '.' }, StringSplitOptions.RemoveEmptyEntries);
//Handled only objects which doesn't have sibling object
if (string.IsNullOrEmpty(difference.ParentPropertyName))
{
foreach (PropertyInfo propertyInfo in original.GetType().GetProperties())
{
if (changedPprts.Contains(propertyInfo.Name))
{
propertyInfo.SetValue(original, propertyInfo.GetValue(stf, null), null);
}
}
}
}
_scEntity.SaveChanges();
}
_Ce.SavedResult = await _repo.GetMyPreference(stf.StaffId);
_Ce.LocalstoreName = "mypreference";
_Ce.UnsavedId = _Ce.SavedId = _Ce.SavedResult.StaffPreferenceId;
_Ce.DeleteUnsavedChanges = true;
_Ce.ShowDetails = false;
_Ce.Details = null;
_Ce.SavedResult = await FindMobileUser(stf.StaffId);
if (stf != null)
{
CommonFunctions <Models.StaffPreferenceModel> .CreateUpdateBriefcase(stf.StaffPreferenceId, _Ce.SavedResult, loggedInUser, CommonDBFunctions.GetGlobalCodeId("BRIEFCASETYPE", "MYPREFERENCE"));
}
return(_Ce);
}
catch (Exception ex)
{
Exception excep = new Exception("Exception occured in MobileStaffRepositiry.Save method." + ex.Message);
throw excep;
}
}
public GroupList GetGroup(int userId)
{
DbParameter[] parameter =
{
DataParameter.GetSqlParam(dbUserEnity.CustomerID.ToString(), SqlDbType.Int, 50, userId, ParameterDirection.Input),
};
try
{
GroupList objGroupList = new GroupList();
var drUserDetails = CommonDBFunctions.ExecuteDataSet(spUser.spUserLogin.ToString(), parameter);
if (drUserDetails.Tables.Count > 0)
{
// new Status() { StatusId = AppConstant.Success, MsgDesc = success };
if (drUserDetails.Tables.Count == 1)
{
if (drUserDetails.Tables[1].Rows.Count > 0)
{
objGroupList.status = new Status()
{
StatusId = AppConstant.Success, MsgDesc = AppConstant.SuccessMsg
};
}
else
{
objGroupList.status = new Status()
{
StatusId = AppConstant.Information, MsgDesc = "No record"
};
}
foreach (DataRow dr in drUserDetails.Tables[1].Rows)
{
GroupDetails objGroup = new GroupDetails();
objGroup.GroupName = dr[dbUserEnity.FirstName.ToString()].ToString();
objGroup.StatusMsg = dr[dbUserEnity.FirstName.ToString()].ToString();
objGroup.Desc = dr[dbUserEnity.FirstName.ToString()].ToString();
objGroup.CreatedUser = dr[dbUserEnity.FirstName.ToString()].ToString();
// objGroup.Status = dr[dbUserEnity.FirstName.ToString()].ToString();
objGroup.CreatedDate = Convert.ToDateTime(dr[dbUserEnity.LastLogin.ToString()].ToString());
objGroup.GroupID = UtilCipher.Encrypt(dr[dbUserEnity.CustomerID.ToString()].ToString());
objGroup.IsAdmin = Convert.ToBoolean(dr[dbUserEnity.FirstName.ToString()]);
objGroupList.groups.Add(objGroup);
}
}
}
return(objGroupList);
}
catch (SqlException ex)
{
throw ex;
}
}
public Status CheckGroup(string group)
{
DbParameter[] parameter =
{
DataParameter.GetSqlParam(DbGroupDetails.GroupName.ToString(), SqlDbType.VarChar, 50, group, ParameterDirection.Input),
DataParameter.GetSqlParam("RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.Output),
};
try
{
return(new Status()
{
StatusId = CommonDBFunctions.ExecuteNonQuery("spGroupCheck", parameter, true), MsgDesc = AppConstant.SuccessMsg
});
}
catch (SqlException ex)
{
throw ex;
}
}
public Status Login1(UserEnity user)
{
DbParameter[] parameter =
{
DataParameter.GetSqlParam(dbUserEnity.UserName.ToString(), SqlDbType.VarChar, 50, user.UserName, ParameterDirection.Input),
DataParameter.GetSqlParam(dbUserEnity.Password.ToString(), SqlDbType.VarChar, 50, user.Password, ParameterDirection.Input),
DataParameter.GetSqlParam("RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.Output),
};
try
{
int RES = CommonDBFunctions.ExecuteNonQuery(spUser.spUserLogin.ToString(), parameter, true);
string success = string.Empty;
switch (RES)
{
case 1:
success = AppConstant.SuccessMsg;
break;
case 2:
success = "User Removed";
break;
case 8:
success = "User Locked";
break;
case 9:
success = "Not activation";
break;
}
return(new Status()
{
StatusId = AppConstant.Success, MsgDesc = success
});
}
catch (SqlException ex)
{
throw ex;
}
}
public Status Insert(GroupDetails objGroup)
{
DbParameter[] parameter =
{
DataParameter.GetSqlParam(DbGroupDetails.GroupName.ToString(), SqlDbType.VarChar, 50, objGroup.GroupName, ParameterDirection.Input),
DataParameter.GetSqlParam(DbGroupDetails.Desc.ToString(), SqlDbType.VarChar, 500, objGroup.Desc, ParameterDirection.Input),
DataParameter.GetSqlParam(DbGroupDetails.CreatedBy.ToString(), SqlDbType.Int, 11, objGroup.CreatedUser, ParameterDirection.Input),
DataParameter.GetSqlParam("RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.Output),
};
try
{
return(new Status()
{
StatusId = CommonDBFunctions.ExecuteNonQuery("spGroupInsert", parameter, true), MsgDesc = AppConstant.SuccessMsg
});
}
catch (SqlException ex)
{
throw ex;
}
}
public Status CheckUserActivation(string guid)
{
DbParameter[] parameter =
{
DataParameter.GetSqlParam(dbUserEnity.ActiveGuid.ToString(), SqlDbType.VarChar, 50, guid, ParameterDirection.Input),
DataParameter.GetSqlParam("RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.Output),
};
try
{
int RES = CommonDBFunctions.ExecuteNonQuery(spUser.spCheckActivation.ToString(), parameter, true);
string success = (RES == 1) ? AppConstant.SuccessMsg : (RES == 2) ? "Activation done already" : "No activation code";
return(new Status()
{
StatusId = AppConstant.Success, MsgDesc = success
});
}
catch (SqlException ex)
{
throw ex;
}
}
/// <summary>
/// Get All the Appointments for the staff based on MobileCalendarEventsDaysLookUpInPast and MobileCalendarEventsDaysLookUpInFuture
/// </summary>
/// <param name="StaffId"></param>
/// <returns></returns>
public List <Models.AppointmentModel> GetCalanderEvents(int StaffId)
{
try
{
List <Models.AppointmentModel> appointments = new List <Models.AppointmentModel>();
var mobStaff = (from a in _ctx.StaffPreferences
where a.StaffId == StaffId
select new
{
backfromCurrentDate = a.MobileCalendarEventsDaysLookUpInPast,
forwardfromCurrentDate = a.MobileCalendarEventsDaysLookUpInFuture
}).FirstOrDefault();
DateTime dtStart = DateTime.Now.AddDays(-(double)mobStaff.backfromCurrentDate);
DateTime dtEnd = DateTime.Now.AddDays((double)mobStaff.forwardfromCurrentDate);
dtEnd = dtEnd.Date.Add(new TimeSpan(23, 59, 59));// To Consider the complete Day
List <Models.AppointmentModel> events = GetServiceAppointments(StaffId, dtStart, dtEnd);
appointments.AddRange(events);
foreach (var calevent in events)
{
if (calevent != null)
{
var briefcaseType = calevent.Service == null?CommonDBFunctions.GetGlobalCodeId("BRIEFCASETYPE", "APPOINTMENT") : CommonDBFunctions.GetGlobalCodeId("BRIEFCASETYPE", "SERVICE");
CommonFunctions <Models.AppointmentModel> .CreateUpdateBriefcase(calevent.AppointmentId, calevent, StaffId, briefcaseType);
}
}
return(appointments);
}
catch (Exception ex)
{
Exception excep = new Exception("Exception occured in BriefcaseRepositiry.GetCalanderEvents method." + ex.Message);
throw excep;
}
}
/// <summary>
/// Retusn My Preference Data for the loggedin staff
/// </summary>
/// <param name="currentStaffId"></param>
/// <returns></returns>
public async Task <Models.StaffPreferenceModel> GetMyPreference(int currentStaffId)
{
try
{
var repo = new MobileStaffRepositiry(new SC.Data.SCMobile());
var user = await repo.FindMobileUser(currentStaffId);
if (user != null)
{
CommonFunctions <Models.StaffPreferenceModel> .CreateUpdateBriefcase(user.StaffPreferenceId, user, currentStaffId, CommonDBFunctions.GetGlobalCodeId("BRIEFCASETYPE", "MYPREFERENCE"));
}
return(user);
}
catch (Exception ex)
{
Exception excep = new Exception("Exception occured in BriefcaseRepositiry.GetMyPreference method." + ex.Message);
throw excep;
}
}
