public LoginResponseMessage AuthenticateUser(LoginRequestMessage RequestMessage)
{
LoginResponseMessage response = null;
try
{
response = ValidateAuthenticateUser(RequestMessage);
if (response != null && response.Error == null)
{
loginDataProvider = new LoginDataProvider();
response = loginDataProvider.AuthenticateUser(RequestMessage);
if (response != null && response.Error == null)
{
//Generate token
response.Success = true;
}
}
}
catch (Exception ex)
{
ErrorLogManager.WriteLog(response, "999", ex.Message, ex: ex);
}
return(response);
}
//protected override void OnInit(EventArgs e)
//{
// this.Page.Theme = "Default";
// base.OnInit(e);
//}
protected void SaveErrorLog(Exception ex)
{
ErrorLog pageEx = new ErrorLog(User.Identity.Name, this.Request.RawUrl, ex);
ErrorLogManager ErrManObj = new ErrorLogManager();
ErrManObj.SavePageExeption(pageEx);
}
protected void SaveErrorLog(Exception ex)
{
ErrorLog pageEx = new ErrorLog("", this.Context.Request.RawUrl, ex);
ErrorLogManager ErrManObj = new ErrorLogManager();
ErrManObj.SavePageExeption(pageEx);
}
public LoginResponseMessage AuthenticateUser(LoginRequestMessage RequestMessage)
{
LoginResponseMessage response = new LoginResponseMessage();
try
{
StringBuilder sqlString = new StringBuilder();
sqlString.Append("select Loginid from LoginDtls where LoginName='");
sqlString.Append(RequestMessage.LoginName);
sqlString.Append("' and cast(Password as varbinary(20))=cast('");
sqlString.Append(RequestMessage.Password);
sqlString.Append("' as varbinary(50)) and IsActive=1");
var login = DataAccessLayer.ExecuteScalar(sqlString.ToString());
if (login != null)
{
response.SecurityToken = "G";
}
else
{
ErrorLogManager.WriteLog(response, "000", "Unable to find user.");
}
}
catch (Exception ex)
{
//ErrorLogManager.WriteLog(response, "999", ex.Message,ex:ex);
ErrorLogManager.WriteLog(response, "012", ex.Message, ex: ex);
}
return(response);
}
private void LoadErrorLog()
{
DataTable dtErrorLog = new DataTable("ErrorLog");
try
{
IFormatProvider cul = new System.Globalization.CultureInfo("VI-vn");
DateTime fromDate = DateTime.ParseExact(txtFromDate.Text, "dd/MM/yyyy", cul);;
DateTime toDate = DateTime.ParseExact(txtToDate.Text, "dd/MM/yyyy", cul);;
string currentUser = txtUserName.Text.Trim();
ErrorLogManager errMan = new ErrorLogManager();
dtErrorLog = errMan.GetErrorLog(fromDate, toDate, currentUser);
if (dtErrorLog.Rows.Count > 0)
{
gvErrorLog.DataSource = dtErrorLog;
gvErrorLog.DataBind();
gvErrorLog.Visible = true;
tblNoData.Visible = false;
uctErrorBox.Visible = false;
}
else
{
tblNoData.Visible = true;
}
}
catch (Exception ex)
{
gvErrorLog.Visible = false;
tblNoData.Visible = false;
uctErrorBox.Visible = true;
this.SaveErrorLog(ex);
}
}
protected override void OnError(EventArgs e)
{
Exception curException = Server.GetLastError().GetBaseException();
ErrorLog errObj = new ErrorLog(User.Identity.Name, this.Request.RawUrl, curException);
ErrorLogManager ErrManObj = new ErrorLogManager();
ErrManObj.SavePageExeption(errObj);
base.OnError(e);
//this.Server.ClearError();
}
private void ShowCustomErrorPage(Exception exception)
{
HttpException httpException = exception as HttpException;
if (httpException == null)
{
httpException = new HttpException(500, "Internal Server Error", exception);
}
Response.Clear();
RouteData routeData = new RouteData();
routeData.Values.Add("controller", "Error");
routeData.Values.Add("fromAppErrorEvent", true);
switch (httpException.GetHttpCode())
{
case 403:
routeData.Values.Add("action", "AccessDenied");
break;
case 404:
routeData.Values.Add("action", "NotFound");
break;
case 500:
routeData.Values.Add("action", "InternalError");
break;
case 502:
routeData.Values.Add("action", "Unavailable");
break;
default:
routeData.Values.Add("action", "Index");
routeData.Values.Add("httpStatusCode", httpException.GetHttpCode());
break;
}
#if !DEBUG
ErrorLogManager errorLogManager = new ErrorLogManager();
ErrorLog log = new ErrorLog()
{
Message = exception.Message,
Name = exception.GetType().FullName,
StatusCode = httpException.GetHttpCode(),
StackTrace = exception.StackTrace
};
errorLogManager.AddAsync(log).ContinueWith(x => x.Dispose());
#endif
Server.ClearError();
IController controller = new ErrorController();
controller.Execute(new RequestContext(new HttpContextWrapper(Context), routeData));
}
/// <summary>
/// log exception to database
/// </summary>
/// <param name="ex"></param>
/// <returns></returns>
private String LogExceptionToDatabase(Exception ex)
{
try
{
//Log exception in database
IErrorLogManager errorlog = new ErrorLogManager();
var result = errorlog.LogExceptionToDatabase(ex);
}
catch (Exception)
{
}
return(null);
}
protected void btnClear_Click(object sender, EventArgs e)
{
try
{
SaveActionLog("Clear", "");
ErrorLogManager errorMan = new ErrorLogManager();
errorMan.ClearErrorLog();
Response.Redirect("Default.aspx");
}
catch (Exception ex)
{
SaveErrorLog(ex);
}
}
private UploadResponseMessage ValidateFile(UploadRequestMessage requestMessage)
{
UploadResponseMessage response = new UploadResponseMessage();
if (requestMessage == null)
{
ErrorLogManager.WriteLog(response, "TestFile", "002", "Request message should not be empty.");
}
else
{
if (string.IsNullOrEmpty(requestMessage.LoginName))
{
ErrorLogManager.WriteLog(response, "TestFile", "003", "Login name is mandatory.");
}
if (string.IsNullOrEmpty(requestMessage.Password))
{
ErrorLogManager.WriteLog(response, "TestFile", "004", "Password is mandatory.");
}
if (requestMessage.gpxFiles == null)
{
ErrorLogManager.WriteLog(response, "TestFile", "005", "File list should not be empty.");
}
else
{
//var item = requestMessage.FileList;
foreach (var item in requestMessage.gpxFiles)
{
if (string.IsNullOrEmpty(item.FileName))
{
ErrorLogManager.WriteLog(response, item.FileName, "006", "File name is mandatory.");
}
if (item.FileData == null)
{
ErrorLogManager.WriteLog(response, item.FileName, "007", "File data should not be empty.");
}
if (item.FileData != null && item.FileData.Length == 0)
{
ErrorLogManager.WriteLog(response, item.FileName, "007", "File data should not be empty.");
}
}
}
}
return(response);
}
public void OnException(ExceptionContext filterContext)
{
if (filterContext.ExceptionHandled || !filterContext.HttpContext.IsCustomErrorEnabled)
{
return;
}
var statusCode = (int)HttpStatusCode.InternalServerError;
if (filterContext.Exception is HttpException)
{
statusCode = (filterContext.Exception as HttpException).GetHttpCode();
}
else if (filterContext.Exception is UnauthorizedAccessException)
{
//to prevent login prompt in IIS
// which will appear when returning 401.
statusCode = (int)HttpStatusCode.Forbidden;
}
else
{
statusCode = 500;
}
#if !DEBUG
// Log the exception
ErrorLogManager errorLogManager = new ErrorLogManager();
ErrorLog log = new ErrorLog()
{
Message = filterContext.Exception.Message,
Name = filterContext.Exception.GetType().FullName,
StatusCode = statusCode,
StackTrace = filterContext.Exception.StackTrace,
ActionName = (string)filterContext.RouteData.Values["action"],
ControllerName = (string)filterContext.RouteData.Values["controller"]
};
errorLogManager.AddAsync(log).ContinueWith(x => x.Dispose());
#endif
var result = CreateActionResult(filterContext, statusCode);
filterContext.Result = result;
// Prepare the response code.
filterContext.ExceptionHandled = true;
filterContext.HttpContext.Response.Clear();
filterContext.HttpContext.Response.StatusCode = statusCode;
filterContext.HttpContext.Response.TrySkipIisCustomErrors = true;
}
public UploadResponseMessage UploadFile(UploadRequestMessage requestMessage, string filePath = "")
{
UploadResponseMessage response = new UploadResponseMessage();
try
{
response = ValidateFile(requestMessage);
if (response != null && response.Log == null)
{
uploadFileDataProvider = new UploadDataProvider();
response = uploadFileDataProvider.UploadFile(requestMessage, filePath);
}
}
catch (Exception ex)
{
ErrorLogManager.WriteLog(response, "TestFile", "999", ex.Message, true, ex: ex);
}
return(response);
}
public void LogError(Exception filterContext)
{
try
{
tbl_ErrorLog tblErrorLog = new tbl_ErrorLog();
tblErrorLog.EntityState = DA.DomainModel.EntityState.Added;
tblErrorLog.ErrorDescription = Convert.ToString(@filterContext.InnerException);
tblErrorLog.ClassName = Convert.ToString(filterContext.TargetSite.ReflectedType.Name);
tblErrorLog.StackTrace = Convert.ToString(@filterContext.StackTrace.ToString());
tblErrorLog.ErrorDate = DateTime.Now;
ErrorLogManager errorlogManager = new ErrorLogManager();
errorlogManager.AddErrorLog(tblErrorLog);
}
catch (Exception)
{
throw;
}
}
public static bool Send(MailMessage msg)
{
string errormsg;
try
{
// msg.From = new MailAddress(Config.Email, Config.AppName);
SmtpClient client = new SmtpClient();
client.EnableSsl = true;
//client.Credentials = new NetworkCredential(Config.Email, Config.Password);
client.Send(msg);
}
catch (Exception ex)
{
errormsg = ex.Message;
IErrorLogManager _errorManager = new ErrorLogManager();
_errorManager.LogStringExceptionToDatabase(errormsg);
return(false);
}
return(true);
}
private LoginResponseMessage ValidateAuthenticateUser(LoginRequestMessage RequestMessage)
{
LoginResponseMessage response = new LoginResponseMessage();
if (RequestMessage == null)
{
ErrorLogManager.WriteLog(response, "002", "Request message should not be empty.");
}
else
{
if (string.IsNullOrEmpty(RequestMessage.LoginName))
{
ErrorLogManager.WriteLog(response, "003", "Login name is mandatory.");
}
if (string.IsNullOrEmpty(RequestMessage.Password))
{
ErrorLogManager.WriteLog(response, "004", "Password is mandatory.");
}
}
return(response);
}
public UploadResponseMessage UploadFile(UploadRequestMessage requestMessage, string filePath = "")
{
UploadResponseMessage response = new UploadResponseMessage();
response.Log = new List <UploadFileStatus>();
try
{
StringBuilder sqlString = new StringBuilder();
sqlString.Append("select * from LoginDtls where LoginName='");
sqlString.Append(requestMessage.LoginName);
sqlString.Append("' and cast(Password as varbinary(20))=cast('");
sqlString.Append(requestMessage.Password);
sqlString.Append("' as varbinary(50)) and IsActive=1");
var login = DataAccessLayer.ReturnDataTable(sqlString.ToString());
if (login != null && login.Rows != null && login.Rows.Count > 0)
{
UserRoleId = Convert.ToInt32(login.Rows[0]["RoleId"]);
UserId = Convert.ToInt32(login.Rows[0]["LoginId"]);
UserName = Convert.ToString(login.Rows[0]["LoginName"]);
if (UserRoleId == 5)
{
sqlString = new StringBuilder();
sqlString.Append("Select * FROM StudentMaster Where LoginId = ");
sqlString.Append(UserId);
var student = DataAccessLayer.ReturnDataTable(sqlString.ToString());
if (student != null && student.Rows.Count > 0)
{
schoolId = Convert.ToInt32(student.Rows[0]["SchoolId"]);
classId = Convert.ToInt32(student.Rows[0]["ClassId"]);
cityId = Convert.ToInt32(student.Rows[0]["CityId"]);
studentId = Convert.ToInt32(student.Rows[0]["StudentId"]);
}
}
else
{
ErrorLogManager.WriteLog(response, "TestFile", "013", "Only Student can upload file.");
return(response);
}
//throw new Exception("To Verify the Error log file writting");
//var item = requestMessage.FileData;
foreach (var item in requestMessage.gpxFiles)
{
Upload(item, response, filePath);
}
}
else
{
ErrorLogManager.WriteLog(response, "TestFile", "000", "Unable to find user.");
}
}
catch (Exception ex)
{
ErrorLogManager.WriteLog(response, "TestFile", "999", ex.Message, ex: ex);
}
return(response);
}
private void Awake()
{
instance = this;
}
protected void Upload(UploadFile PostedFile,
UploadResponseMessage response, string filePath)
{
string FileName = string.Empty;
try
{
BCCityAdmin cityContent = new BCCityAdmin();
DateTime cityStartDate = new DateTime();
DataTable _dtTrkpts = new DataTable();
DataTable studInfo = null;
FileName = PostedFile.FileName;
string NewFile = "";
string NewFileName = "";
string FilePath = string.Empty;
studInfo = objStudent.GetMyProfileInfo(studentId);
schoolId = Convert.ToInt32(studInfo.Rows[0]["SchoolId"]);
classId = Convert.ToInt32(studInfo.Rows[0]["ClassId"]);
FilePath = filePath + schoolId + @"\" +
classId + @"\" + studentId.ToString() + @"\".ToString();
System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(FilePath);
if (!(dir.Exists))
{
System.IO.Directory.CreateDirectory(FilePath);
}
//string extension = System.IO.Path.GetExtension(FileName).ToLower();
string[] extention = FileName.Split('.');
if (extention != null && extention.Count() > 0)
{
FileName = extention[0];
}
//if ((extension == ".gpx") | (extension == ".GPX"))
//{
if (IsFileUploaded(FilePath + FileName + ".xml"))
{
ErrorLogManager.WriteLog(response, FileName, "008", "File already uploaded!");
}
else
{
#region Save file on server for evaluation
File.WriteAllBytes(FilePath + FileName + ".xml", PostedFile.FileData);
DataTable dt = cityContent.GetCityContent(Convert.ToInt32(studInfo.Rows[0]["CityId"]), 0);
try
{
string TimeStamp = DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() +
DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + "";
NewFileName = UserRoleId.ToString() + "_" + UserId.ToString() + "_" + TimeStamp + ".xml";
File.Move(FilePath + FileName + ".xml", FilePath + NewFileName); // Try to move
NewFile = FilePath + NewFileName;
}
catch (IOException ex)
{
NewFile = FilePath + FileName;
NewFileName = FileName;
}
//File.WriteAllBytes(FilePath + FileName + ".xml", PostedFile.FileData);
////fu_UploadGpx.SaveAs(FilePath + FileName.Replace(".gpx", ".xml"));
//DataTable dt = cityContent.GetCityContent(cityId, 0);
//XElement root = null;
//DateTime DateOfFile = new DateTime();
//try
//{
// root = XElement.Load(FilePath + FileName + ".xml");
// DateOfFile = DateTime.Parse(root.Elements().Skip(1).Take(1).Elements().Take(1).ToList()[0].Value);
//}
//catch (Exception ex)
//{
// ErrorLogManager.WriteLog(response,FileName, "009", "Uploaded File does not have Time Information, Please check the file and re-upload");
// return;
//}
//if (dt != null && dt.Rows.Count > 0)
//{
// cityStartDate = (dt.Rows[0]["CityStartDate"] != DBNull.Value ? Convert.ToDateTime(dt.Rows[0]["CityStartDate"]) : new DateTime());
// if (cityStartDate != new DateTime() &&
// DateOfFile != new DateTime() &&
// DateOfFile.Date <= cityStartDate.Date)
// {
// ErrorLogManager.WriteLog(response,FileName, "010", "File can not be uploaded prior to Batch Start Date.");
// return;
// }
//}
//try
//{
// string TimeStamp = DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() +
// DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + "";
// NewFileName = UserRoleId.ToString() + "_" + UserId.ToString() + "_" + TimeStamp + ".xml";
// File.Move(FilePath + FileName + ".xml", FilePath + NewFileName); // Try to move
// NewFile = FilePath + NewFileName;
//}
//catch (IOException ex)
//{
// NewFile = FilePath + FileName + ".xml";
// NewFileName = FileName;
//}
#endregion
DataTable dtNew = new DataTable();
dtNew = LoadGPXWaypoints(NewFile);
DateTime DateOfFile = DateTime.MinValue;;
if (dt != null && dt.Rows.Count > 0 && dtNew != null && dtNew.Rows.Count > 0)
{
cityStartDate = Convert.ToDateTime(dt.Rows[0]["CityStartDate"]);
DateOfFile = Convert.ToDateTime(dtNew.Rows[0]["time"]);
}
if ((cityStartDate != new DateTime() &&
DateOfFile <= cityStartDate) ||
(DateOfFile < DateTime.Parse(ConfigurationManager.AppSettings["BatchStartDate"])))
{
ErrorLogManager.WriteLog(response, FileName, "010", "File can not be uploaded prior to Batch Start Date.");
return;
}
_dtTrkpts = dtNew;
int trackCount = dtNew.Rows.Count; //(dtNew.Rows.Count / 5) + 1;
double highestSpeed = 0;
DataTable dtNewRows = CheckPreviousGPXTrackPointsNew(UserId,
schoolId,
classId, dtNew);
if (dtNewRows != null &&
dtNewRows.Rows.Count > 0)
{
double distance = CalculateTotalDistance(dtNewRows);
double time = CalculateTotalTime(dtNewRows);
double timeAvg = CalculateAvgTime(dtNewRows);
#region Calculate Average Speed
if (timeAvg > 0)
{
time = timeAvg;
}
double avgSpeed = 0.0;
if (time > 0)
{
avgSpeed = distance / time;
}
#endregion
int speedLimit = 15;
if (ConfigurationManager.AppSettings["SpeedLimit"].ToString() != "")
{
speedLimit = Convert.ToInt32(ConfigurationManager.AppSettings["SpeedLimit"]);
}
if (avgSpeed == 0)
{
ErrorLogManager.WriteLog(response, FileName, "011", "Invalid file!");
File.Delete(NewFile);
}
else
{
highestSpeed = GetHighestSpeedInGPX(dtNewRows);
#region Check ongoing stage information
int stagePlanId = 0;
double stageDistance = 0;
double distCovered = 0;
DataSet _dtStage = objStudent.GetCurrentStageInfo((studentId > 0 ? studentId : UserId),
UserRoleId, classId);
if (_dtStage.Tables[0].Rows.Count > 0)
{
stagePlanId = Convert.ToInt32(_dtStage.Tables[0].Rows[0]["StagePlanId"]);
stageDistance = Convert.ToDouble(_dtStage.Tables[0].Rows[0]["Distance"]);
distCovered = double.Parse(_dtStage.Tables[0].Rows[0]["Distance_Covered"].ToString(), System.Globalization.CultureInfo.InvariantCulture);
//Convert.ToDouble(_dtStage.Tables[0].Rows[0]["Distance_Covered"]);
}
#endregion
//if (avgSpeed > speedLimit)
//{
// ErrorLogManager.WriteLog(response, FileName, "016", "Speed Limit Crossed!");
//}
//else
if (avgSpeed <= speedLimit && highestSpeed <= speedLimit)
{
//Save data in Student Uploads
#region Save data in Student Uploads
// Check for similar track points
int res = objStudent.StudentsUpload(
UserRoleId, UserId,
0, studentId,
stagePlanId, stageDistance, distCovered, (NewFile), NewFileName,
DateTime.Now, distance, time, classId, 1, trackCount);
if (res > 0)
{
_SaveTrackPoints(_dtTrkpts, res);
ErrorLogManager.WriteLog(response, FileName, "012", "File uploaded successfully!", false);
}
else
{
ErrorLogManager.WriteLog(response, FileName, "008", "File already uploaded!");
File.Delete(NewFile);
}
#endregion
}
else // Upload file out of speed limit. No change in stage distance.
{
#region Save data in Student Uploads
int res = objStudent.StudentsUploadExtraSpeed(
UserRoleId, UserId,
0,
studentId, stagePlanId,
stageDistance, distCovered, (NewFile), NewFileName,
DateTime.Now, distance, time, classId, 0, trackCount);
if (res > 0)
{
_SaveTrackPoints(_dtTrkpts, res);
#region Send email to Class Admin & City Admin for speed limit
if (avgSpeed > speedLimit || highestSpeed > speedLimit)
{
try
{
string ClassAdminEmail = studInfo.Rows[0]["ClassAdminEmail"].ToString();
string CityAdminEmail = studInfo.Rows[0]["CityAdminEmail"].ToString();
StringBuilder sb = new StringBuilder();
sb.Append("<p>Dear " + studInfo.Rows[0]["ClassAdminName"].ToString() + ",</p>");
sb.Append("<p><b>" + UserName + " (Student in " + studInfo.Rows[0]["School"].ToString() + ", " + studInfo.Rows[0]["Class"].ToString() + ")</b> have uploaded a GPX file (" + NewFileName + ") with speed <b>" + avgSpeed.ToString() + " Kmph and heighest speed being " + highestSpeed + "</b>.</p>");
sb.Append("<p>Kindly approve or reject file manually.</p>");
Helper.sendMailMoreThanAvgSpeed("BikeTour - Speed Limit Crossed!", ClassAdminEmail, sb.ToString());
StringBuilder sb2 = new StringBuilder();
sb2.Append("<p>Dear " + studInfo.Rows[0]["CityAdminName"].ToString() + ",</p>");
sb.Append("<p><b>" + UserName + " (Student in " + studInfo.Rows[0]["School"].ToString() + ", " + studInfo.Rows[0]["Class"].ToString() + ")</b> have uploaded a GPX file (" + NewFileName + ") with speed <b>" + avgSpeed.ToString() + "Kmph and heighest speed being " + highestSpeed + "</b>.</p>");
sb.Append("<p>Kindly approve or reject file manually.</p>");
Helper.sendMailMoreThanAvgSpeed("BikeTour - Speed Limit Crossed!", ClassAdminEmail, sb2.ToString());
}
catch (Exception ex)
{
}
}
#endregion
ErrorLogManager.WriteLog(response, FileName, "012", "File uploaded successfully!", false);
}
else
{
ErrorLogManager.WriteLog(response, FileName, "008", "File already uploaded!");
File.Delete(NewFile);
}
#endregion
}
}
}
else
{
ErrorLogManager.WriteLog(response, FileName, "008", "File already uploaded!");
}
}
}
catch (Exception ex)
{
ErrorLogManager.WriteLog(response, FileName, "013", "Select GPX file!" + ex.Message);
}
}
