public SessionUpdateResponse UpdateSessionId(int UserId) { string SessionId = string.Empty; SessionUpdateResponse SessionUpdateResponse = new SessionUpdateResponse(); SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "UpdateSessionId", "Start For UserID -" + UserId); try { DataAccessLayer.DataAccessLayer DBLayer = new DataAccessLayer.DataAccessLayer(); SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "UpdateSessionId", "Generating SessionId for UserId: " + UserId); string Sessionid = System.Guid.NewGuid().ToString(); SICTLogger.WriteVerbose(UserDetailsBusiness.CLASS_NAME, "UpdateSessionId", "Inserting Session Id into the Session Table for UserId- " + UserId); SessionId = DBLayer.InsertValuesToSessionTable(Sessionid, UserId); if (!string.IsNullOrEmpty(SessionId)) { SessionUpdateResponse.ReturnCode = 1; SessionUpdateResponse.ReturnMessage = "Updationg SessionId Successful"; SessionUpdateResponse.SessionId = SessionId; } else { SessionUpdateResponse.ReturnCode = -1; SessionUpdateResponse.ReturnMessage = "Updationg SessionId Failed in DB"; } } catch (System.Exception Ex) { SessionUpdateResponse.ReturnCode = -1; SessionUpdateResponse.ReturnMessage = "Error in API"; SICTLogger.WriteException(UserDetailsBusiness.CLASS_NAME, "UpdateSessionId", Ex); } SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "UpdateSessionId", "End For UserId " + UserId); return(SessionUpdateResponse); }
public LoginInformation CompareHashAndAuthenticate(string HashString) { LoginInformation LoginInformation = new LoginInformation(); SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "CompareHashAndAuthenticate ", "Start "); try { string UName = string.Empty; DataAccessLayer.DataAccessLayer DBLayer = new DataAccessLayer.DataAccessLayer(); DataTable DataTable = new DataTable(); DataTable DtUpload = new DataTable(); bool IsAuthenticatedUser = false; DataTable = DBLayer.GetAllUserNameAndPassword(); DtUpload = DBLayer.GetLastUploadDate(); foreach (DataRow Dr in DataTable.Rows) { string UserName = Dr[BusinessConstants.USERNAME].ToString(); string Password = Dr[BusinessConstants.PASSWORD].ToString(); string UserNameAndPassword = string.Format("{0}&{1}", UserName, Password); if (string.Compare(this.CreateMD5Hash(UserNameAndPassword), HashString, true) == 0) { UName = UserName; LoginInformation = this.Authenticate(Dr); IsAuthenticatedUser = true; break; } } if (!IsAuthenticatedUser) { LoginInformation.ReturnCode = 0; LoginInformation.SessionId = null; LoginInformation.ReturnMessage = "Invalid Username or Password"; } if (DtUpload.Rows.Count > 0) { System.Collections.Generic.List <string> UploadDates = new System.Collections.Generic.List <string>(); string UploadDate = string.Empty; if (!string.IsNullOrEmpty(DtUpload.Rows[0][BusinessConstants.LASTUPLOADDATE].ToString())) { UploadDate = System.Convert.ToDateTime(DtUpload.Rows[0][BusinessConstants.LASTUPLOADDATE].ToString()).ToUniversalTime().ToString(); UploadDate = System.Convert.ToDateTime(UploadDate).ToString("MM/dd/yyyy/HH/mm"); UploadDate = UploadDate.Replace(".", "/"); UploadDate = UploadDate.Replace(":", "/"); LoginInformation.LastUploadDate = UploadDate; } } LoginInformation.IsSpecialUser = this.CheckIsSpecialUserOrNot(UName); LoginInformation.AirportId = System.Convert.ToInt32(DBLayer.GetAirportIdByUserName(UName)); } catch (System.Exception Ex) { LoginInformation.ReturnCode = -1; LoginInformation.ReturnMessage = "Error in Function Execution"; SICTLogger.WriteException(UserDetailsBusiness.CLASS_NAME, "CompareHashAndAuthenticate ", Ex); } SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "CompareHashAndAuthenticate ", "End"); return(LoginInformation); }
private void BulkInsert(string UploadFilePath, string Instance) { try { DataAccessLayer.DataAccessLayer DBLayer = new DataAccessLayer.DataAccessLayer(); int MaxCnt = System.Convert.ToInt32(ConfigurationManager.AppSettings[BusinessConstants.UPLOAD_ROWS_CNT].ToString()); DataTable Dt = new DataTable(); Dt.Columns.Add(BusinessConstants.CONFIRMIT_CARD_NUMBER, typeof(long)); Dt.Columns.Add(BusinessConstants.CONFIRMIT_CLASS, typeof(string)); Dt.Columns.Add(BusinessConstants.CONFIRMIT_STATUS, typeof(string)); Dt.Columns.Add(BusinessConstants.CONFIRMIT_DATETIME, typeof(System.DateTime)); using (System.IO.StreamReader ReadFile = new System.IO.StreamReader(UploadFilePath)) { int CurIndex = 0; string line; while ((line = ReadFile.ReadLine()) != null) { string[] RowValues = line.Split(new char[] { ',' }); if (!string.IsNullOrEmpty(RowValues[0]) && !string.IsNullOrEmpty(RowValues[1]) && !string.IsNullOrEmpty(RowValues[2]) && !string.IsNullOrEmpty(RowValues[3])) { DataRow Dr = Dt.NewRow(); Dr[BusinessConstants.CONFIRMIT_CARD_NUMBER] = System.Convert.ToInt64(RowValues[0]); Dr[BusinessConstants.CONFIRMIT_CLASS] = RowValues[1].ToString(); Dr[BusinessConstants.CONFIRMIT_STATUS] = RowValues[2].ToString(); Dt.Rows.Add(Dr); } CurIndex++; if (CurIndex == MaxCnt || ReadFile.EndOfStream) { bool IsLastbatch = false; if (ReadFile.EndOfStream) { IsLastbatch = true; } SICTLogger.WriteWarning(UploadBusiness.CLASS_NAME, "BulkInsert", "Bulk Copy Initiated for current index" + CurIndex); DBLayer.BulkCopy(Dt, IsLastbatch); if (IsLastbatch) { DBLayer.OnSqlRowsCopied(null, null); } CurIndex = 0; Dt.Clear(); } } } Task.Factory.StartNew <ReturnValue>(() => new CacheFileBusiness().CreateCacheFileforTargetVsCompletesCharts(Instance)); } catch (System.Exception Ex) { SICTLogger.WriteException(UploadBusiness.CLASS_NAME, "BulkInsert", Ex); } }
private void DownloadDataInBackground(string SessionId, DepartureFormFilterDetails DepartureFormFilterDetails, string FilePath) { DownloadResponse DownloadResponse = new DownloadResponse(); SICTLogger.WriteInfo(DownloadBusiness.CLASS_NAME, "DownloadDataInBackground", "Start "); try { DepartureFormBusiness ObjDepartureFormBusiness = new DepartureFormBusiness(); DataAccessLayer.DataAccessLayer DBLayer = new DataAccessLayer.DataAccessLayer(); System.Collections.Generic.List <DepartureFormDetails> DepartureFormDetails = new System.Collections.Generic.List <DepartureFormDetails>(); string OrderByCondition = string.Empty; string WhereCondition = string.Empty; Workbook Wb = new Workbook(); Worksheet DataSheet = null; this.AddDataSheetToWorkBook(ref Wb, ref DataSheet, "Forms"); this.InsertFormFilterstoWorkBook(ref DataSheet, DepartureFormFilterDetails); ObjDepartureFormBusiness.BuildOrderByandWhereConditions(DepartureFormFilterDetails, ref OrderByCondition, ref WhereCondition); int RecordsPerLoop = System.Convert.ToInt32(ConfigurationManager.AppSettings[BusinessConstants.UPLOAD_ROWS_CNT].ToString()); int StartIndex = 0; int Count = 0; bool IsFirstRecord = true; int DataRow = 1; do { DataSet DSCardDetails = new DataSet(); DSCardDetails = DBLayer.GetGlobalDepartureFormDetailst(SessionId, StartIndex, RecordsPerLoop, OrderByCondition, WhereCondition, DepartureFormFilterDetails.AirportId, DepartureFormFilterDetails.IsDepartureForm, false, 0L, 0L); if (DSCardDetails.Tables.Count == 2) { if (IsFirstRecord) { Count = System.Convert.ToInt32(DSCardDetails.Tables[0].Rows[0][BusinessConstants.FORM_TOTALRECORDS].ToString()); IsFirstRecord = false; } this.InsertFormDataToWorksheet(DSCardDetails.Tables[1], ref DataSheet, ref DataRow); StartIndex += RecordsPerLoop; if (StartIndex < Count && StartIndex + RecordsPerLoop > Count) { RecordsPerLoop = Count - StartIndex; } } }while (StartIndex < Count); Wb.Save(FilePath, new OoxmlSaveOptions(SaveFormat.Xlsx)); } catch (System.Exception Ex) { DownloadResponse.ReturnCode = -1; DownloadResponse.ReturnMessage = "Error in Function "; SICTLogger.WriteException(DownloadBusiness.CLASS_NAME, "DownloadDataInBackground", Ex); } }
public void AddAuditLog(string SessionId, string SourceType, string AuditType, string Description, string BrowserDetail = null, string DataRecieved = null) { try { DataAccessLayer.DataAccessLayer DBLayer = new DataAccessLayer.DataAccessLayer(); Task.Factory.StartNew(delegate { DBLayer.AddAuditLogInfo(SessionId, SourceType, AuditType, Description, BrowserDetail, DataRecieved); }); } catch (System.Exception Ex) { SICTLogger.WriteException(AuditLogBusiness.CLASS_NAME, "AddAuditLog", Ex); } }
public bool IsSessionIdValid(string SessionId, bool IsValidCheck = false) { bool IsValid = false; SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "IsSessionIdValid", " Start for Session id-" + SessionId); DataTable DT = new DataTable(); try { DataAccessLayer.DataAccessLayer DBLayer = new DataAccessLayer.DataAccessLayer(); IsValid = DBLayer.CheckSessionIdExisistOrNot(SessionId, IsValidCheck); } catch (System.Exception Ex) { SICTLogger.WriteException(UserDetailsBusiness.CLASS_NAME, "IsSessionIdValid", Ex); } SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "IsSessionIdValid", "End for SessonId -" + SessionId); return(IsValid); }
private string GenerateSessionId(int UserId) { string IsInsertSuccessful = string.Empty; SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "GenerateSessionId", "Start For UserID -" + UserId); try { DataAccessLayer.DataAccessLayer DBLayer = new DataAccessLayer.DataAccessLayer(); SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "GenerateSessionId", "Generating SessionId for UserId: " + UserId); string Sessionid = System.Guid.NewGuid().ToString(); SICTLogger.WriteVerbose(UserDetailsBusiness.CLASS_NAME, "GenerateSessionId", "Inserting Session Id into the Session Table for UserId- " + UserId); IsInsertSuccessful = DBLayer.InsertValuesToSessionTable(Sessionid, UserId); } catch (System.Exception Ex) { SICTLogger.WriteException(UserDetailsBusiness.CLASS_NAME, "GenerateSessionId", Ex); } SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "GenerateSessionId", "End For UserId " + UserId); return(IsInsertSuccessful); }
public ReturnValue UpdateUser(UserDetail UserDetail, string Instance) { ReturnValue ReturnValue = new ReturnValue(); SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "UpdateUser", "Start "); try { DataAccessLayer.DataAccessLayer DBLayer = new DataAccessLayer.DataAccessLayer(); SICTLogger.WriteVerbose(UserDetailsBusiness.CLASS_NAME, "UpdateUser", "Inserting Interviewer to DB Start"); ReturnValue = DBLayer.UpdateUser(UserDetail); Task.Factory.StartNew <ReturnValue>(() => new CacheFileBusiness().CreateCacheFileforAiprort()); Task.Factory.StartNew <ReturnValue>(() => new CacheFileBusiness().CreateCacheFileforTargetVsCompletesCharts(Instance)); } catch (System.Exception Ex) { SICTLogger.WriteException(UserDetailsBusiness.CLASS_NAME, "UpdateUser", Ex); ReturnValue.ReturnCode = -1; ReturnValue.ReturnMessage = "Error in API"; } SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "UpdateUser", "End"); return(ReturnValue); }
public ReturnValue AddUser(UserDetail UserDetail, string Instance) { ReturnValue ReturnValue = new ReturnValue(); SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "AddUser", "Start "); try { DataAccessLayer.DataAccessLayer DBLayer = new DataAccessLayer.DataAccessLayer(); SICTLogger.WriteVerbose(UserDetailsBusiness.CLASS_NAME, "AddUser", "Inserting User Details to DB Start"); ReturnValue = DBLayer.AddUser(UserDetail.AirportName, UserDetail.UserName, UserDetail.Password, UserDetail.RoleId, UserDetail.IsActive, UserDetail.ArrivalFormAccess, UserDetail.DepartureFormAccess, UserDetail.IsLogin); Task.Factory.StartNew <ReturnValue>(() => new CacheFileBusiness().CreateCacheFileforAiprort()); Task.Factory.StartNew <ReturnValue>(() => new CacheFileBusiness().CreateCacheFileforTargetVsCompletesCharts(Instance)); } catch (System.Exception Ex) { SICTLogger.WriteException(UserDetailsBusiness.CLASS_NAME, "AddUser", Ex); ReturnValue.ReturnCode = -1; ReturnValue.ReturnMessage = "Error in API"; } SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "AddUser", "End"); return(ReturnValue); }
public Client() { var logIn = new LogIn(); if (logIn.ShowDialog() == DialogResult.OK) { _dal = new DataAccessLayer.DataAccessLayer(logIn.DataType, logIn.ConnectionParameters); } var authorization = new Authorization(); authorization.LookInDb += Authorization_LookInDB; if (authorization.ShowDialog() == DialogResult.OK) { MessageBox.Show(@" Авторизация пройдена Вы вошли под именем " + _currentUser.UserName + @", Admin - " + _currentUser.IsAdmin + @" Ваше настоящее имя " + _currentUser.Name); } else { return; } authorization.LookInDb -= Authorization_LookInDB; InitializeComponent(); Button_Refresh_Click(null, null); Button_RefreshMagazine_Click(null, null); Button_RefreshArticle_Click(null, null); if (_currentUser != null) { label_UserName.Text = $@"Здраствуйте, {_currentUser.Name}"; } }
// Function to fetch login data from database public DataTable LOGIN(string ID, string PWD) { // Create instance from DataAccessLayer DataAccessLayer.DataAccessLayer DAL = new DataAccessLayer.DataAccessLayer(); // SP parameters SqlParameter[] param = new SqlParameter[2]; // @ID , @PWD param[0] = new SqlParameter("ID", SqlDbType.VarChar, 50); param[0].Value = ID; param[1] = new SqlParameter("PWD", SqlDbType.VarChar, 50); param[1].Value = PWD; // Open Connection with Database DAL.Open(); // execute SP DataTable Dt = new DataTable(); Dt = DAL.SelectData(sp, param); return(Dt); }
public Logger(ConnectionOptions options, IConverter converter) { logOptions = options; dal = new DataAccessLayer.DataAccessLayer(converter, options); }
public Logger(LoggingOptions loggingOptions, IParser parser) { LoggingOptions = loggingOptions; DAL = new DataAccessLayer.DataAccessLayer(loggingOptions.ConnectingOptions, parser); }
public ServiceLayer(DataAccessLayer.Options.ConnectionOptions options) { DAL = new DataAccessLayer.DataAccessLayer(options); }
public UserBL(IConfiguration configuration) { this.dataAccessLayer = new DataManagment.DataAccessLayer.DataAccessLayer(configuration["SqlConnection:ConnectionString"]); }
/// <summary> /// This Function is used to create TargetVsCompletes Charts for Each active Airport Login and Store it in the Aproapriate path /// </summary> /// <returns></returns> public ReturnValue CreateCacheFileforTargetVsCompletesCharts() { const string FUNCTION_NAME = "CreateCacheFileforTargetVsCompletesCharts"; ReturnValue RetValue = new ReturnValue(); SICTLogger.WriteInfo(CLASS_NAME, FUNCTION_NAME, "Start"); try { DataAccessLayer.DataAccessLayer DBLayer = new DataAccessLayer.DataAccessLayer(); DataTable DtLogin = new DataTable(); SICTLogger.WriteVerbose(CLASS_NAME, FUNCTION_NAME, "Retrieving all Airport login's from DB"); DtLogin = DBLayer.GetAllAirportLogins(); if (DtLogin.Rows.Count > 1) { for (int LoginCnt = 0; LoginCnt < DtLogin.Rows.Count; LoginCnt++) { int AirportLoginId = Convert.ToInt32(DtLogin.Rows[LoginCnt][BusinessConstants.AIRPORTLOGINID].ToString()); List <TargetsVsCompletes> TargetsandCompletes = new List <TargetsVsCompletes>(); List <MissingTargetsVsBusinessClass> MissingTargetsVsBusinessClass = new List <MissingTargetsVsBusinessClass>(); DataSet DSTargetCompletes = new DataSet(); SICTLogger.WriteVerbose(CLASS_NAME, FUNCTION_NAME, "Retrieving all Targets and Completes for the Airport login -" + AirportLoginId); DSTargetCompletes = DBLayer.GetTargetandCompleteforAirportLogin(AirportLoginId); if (DSTargetCompletes.Tables.Count > 2) { foreach (DataRow DrTarget in DSTargetCompletes.Tables[0].Rows) { //Target Vs Business Class TargetsVsCompletes TempTargetsandCompletes = new TargetsVsCompletes(); int AirlineId = Convert.ToInt32(DrTarget[BusinessConstants.AIRLINEID].ToString()); int Target = Convert.ToInt32(DrTarget[BusinessConstants.TARGET].ToString()); string AirlineName = DrTarget[BusinessConstants.AIRLINENAME].ToString(); int Completes = 0; DataRow[] DrCompletes = DSTargetCompletes.Tables[1].Select(BusinessConstants.AIRLINEID + "=" + AirlineId); if (DrCompletes.Length > 0) { Completes = Convert.ToInt32(DrCompletes[0][BusinessConstants.COMPLETES].ToString()); } TempTargetsandCompletes.AirlineId = AirlineId; TempTargetsandCompletes.AirlineName = AirlineName; TempTargetsandCompletes.Target = Target; TempTargetsandCompletes.Completes = Completes; TargetsandCompletes.Add(TempTargetsandCompletes); //Missing Targets Vs Missing Business Class MissingTargetsVsBusinessClass TempMissingTargetsVsBusinessClass = new MissingTargetsVsBusinessClass(); int BusinessCompletes = 0; DataRow[] DrBusinessCompletes = DSTargetCompletes.Tables[2].Select(BusinessConstants.AIRLINEID + "=" + AirlineId); if (DrBusinessCompletes.Length > 0) { BusinessCompletes = Convert.ToInt32(DrBusinessCompletes[0][BusinessConstants.BUSINESSCOMPLETES].ToString()); } TempMissingTargetsVsBusinessClass.AirlineId = AirlineId; TempMissingTargetsVsBusinessClass.AirlineName = DrTarget[BusinessConstants.AIRLINENAME].ToString(); TempMissingTargetsVsBusinessClass.MissingTarget = Target - Completes; TempMissingTargetsVsBusinessClass.MissingCompletes = (Target * (1 / 3)) - Convert.ToDouble(BusinessCompletes); MissingTargetsVsBusinessClass.Add(TempMissingTargetsVsBusinessClass); } } WriteTargetVsCompletesChartsCacheFile(AirportLoginId.ToString(), TargetsandCompletes); WriteMissingTargetsVsBusinessClassChartCacheFile(AirportLoginId.ToString(), MissingTargetsVsBusinessClass); } } //Admin Cache File Creation List <TargetsVsCompletes> AllTargetsandCompletes = new List <TargetsVsCompletes>(); List <MissingTargetsVsBusinessClass> AllMissingTargetsVsBusinessClass = new List <MissingTargetsVsBusinessClass>(); DataSet DSAll = DBLayer.GetAllTargetandComplete(); if (DSAll.Tables.Count > 2) { foreach (DataRow DrTarget in DSAll.Tables[0].Rows) { //Target Vs Business Class TargetsVsCompletes TempTargetsandCompletes = new TargetsVsCompletes(); int AirlineId = Convert.ToInt32(DrTarget[BusinessConstants.AIRLINEID].ToString()); int Target = Convert.ToInt32(DrTarget[BusinessConstants.TARGET].ToString()); string AirlineName = DrTarget[BusinessConstants.AIRLINENAME].ToString();; int Completes = 0; DataRow[] DrCompletes = DSAll.Tables[1].Select(BusinessConstants.AIRLINEID + "=" + AirlineId); if (DrCompletes.Length > 0) { Completes = Convert.ToInt32(DrCompletes[0][BusinessConstants.COMPLETES].ToString()); } TempTargetsandCompletes.AirlineId = AirlineId; TempTargetsandCompletes.AirlineName = DrTarget[BusinessConstants.AIRLINENAME].ToString(); TempTargetsandCompletes.Target = Convert.ToInt32(DrTarget[BusinessConstants.TARGET].ToString()); TempTargetsandCompletes.Completes = Completes; AllTargetsandCompletes.Add(TempTargetsandCompletes); //Missing Targets Vs Missing Business Class MissingTargetsVsBusinessClass TempMissingTargetsVsBusinessClass = new MissingTargetsVsBusinessClass(); int BusinessCompletes = 0; DataRow[] DrBusinessCompletes = DSAll.Tables[2].Select(BusinessConstants.AIRLINEID + "=" + AirlineId); if (DrBusinessCompletes.Length > 0) { BusinessCompletes = Convert.ToInt32(DrBusinessCompletes[0][BusinessConstants.BUSINESSCOMPLETES].ToString()); } TempMissingTargetsVsBusinessClass.AirlineId = AirlineId; TempMissingTargetsVsBusinessClass.AirlineName = DrTarget[BusinessConstants.AIRLINENAME].ToString(); TempMissingTargetsVsBusinessClass.MissingTarget = Target - Completes; TempMissingTargetsVsBusinessClass.MissingCompletes = (Target * 0.30) - Convert.ToDouble(BusinessCompletes); AllMissingTargetsVsBusinessClass.Add(TempMissingTargetsVsBusinessClass); } } WriteTargetVsCompletesChartsCacheFile("Admin", AllTargetsandCompletes); WriteMissingTargetsVsBusinessClassChartCacheFile("Admin", AllMissingTargetsVsBusinessClass); } catch (Exception Ex) { RetValue.ReturnCode = 2; RetValue.ReturnMessage = "Cache file creation Failed - error in API "; SICTLogger.WriteException(CLASS_NAME, FUNCTION_NAME, Ex); } SICTLogger.WriteInfo(CLASS_NAME, FUNCTION_NAME, "End"); return(RetValue); }
private LoginInformation Authenticate(DataRow UserDetails) { LoginInformation LoginReturnValue = new LoginInformation(); SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "Authenticate ", "Start "); try { DataAccessLayer.DataAccessLayer DBLayer = new DataAccessLayer.DataAccessLayer(); SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "Authenticate ", "Entered Authentication: - UserName-" + UserDetails["UserName"].ToString()); int UserId = System.Convert.ToInt32(UserDetails[BusinessConstants.USERID].ToString()); string UserName = UserDetails[BusinessConstants.USERNAME].ToString(); string Password = UserDetails[BusinessConstants.PASSWORD].ToString(); string Role = UserDetails[BusinessConstants.ROLE].ToString(); string AirportName = string.Empty; bool DepartureFormAccess = false; bool ArivalFormAccess = false; bool IsSuperAdmin = false; if (!string.IsNullOrEmpty(UserDetails[BusinessConstants.DEPARTUREFORMACCESS].ToString())) { DepartureFormAccess = System.Convert.ToBoolean(UserDetails[BusinessConstants.DEPARTUREFORMACCESS].ToString()); } if (!string.IsNullOrEmpty(UserDetails[BusinessConstants.ARIVALFORMACCESS].ToString())) { ArivalFormAccess = System.Convert.ToBoolean(UserDetails[BusinessConstants.ARIVALFORMACCESS].ToString()); } if (!string.IsNullOrEmpty(UserDetails[BusinessConstants.AIRPORTNAME].ToString())) { AirportName = UserDetails[BusinessConstants.AIRPORTNAME].ToString(); } if (!string.IsNullOrEmpty(UserDetails[BusinessConstants.ISSUPERADMIN].ToString())) { IsSuperAdmin = System.Convert.ToBoolean(UserDetails[BusinessConstants.ISSUPERADMIN].ToString()); } double LoggedInDuration = 0.0; bool IsAuthenticatedUser = false; SICTLogger.WriteVerbose(UserDetailsBusiness.CLASS_NAME, "Authenticate ", "Checking if the user as already logged in - "); bool IsUserLoggedIn = DBLayer.IsUserAlreadyLoggedIn(UserId, ref LoggedInDuration); if (!IsUserLoggedIn || (IsUserLoggedIn && LoggedInDuration > System.Convert.ToDouble(ConfigurationManager.AppSettings[BusinessConstants.SESSIONEXPIRYTIME]))) { LoginReturnValue.SessionId = this.GenerateSessionId(UserId); } else if (IsUserLoggedIn && LoggedInDuration < System.Convert.ToDouble(ConfigurationManager.AppSettings[BusinessConstants.SESSIONEXPIRYTIME])) { LoginReturnValue.SessionId = DBLayer.GetExistingSessionIdAndUpdateTime(UserId); } SICTLogger.WriteVerbose(UserDetailsBusiness.CLASS_NAME, "Authenticate ", "Assinging values for the LoginInformation Class"); LoginReturnValue.AirportLoginId = UserId; LoginReturnValue.AirportName = AirportName; LoginReturnValue.RoleId = Role.ToString(); LoginReturnValue.DepartureFormAccess = DepartureFormAccess; LoginReturnValue.ArivalFormAccess = ArivalFormAccess; LoginReturnValue.IsSuperAdmin = IsSuperAdmin; LoginReturnValue.ReturnCode = 1; LoginReturnValue.IsValidUser = true; LoginReturnValue.ReturnMessage = "Login Successful"; new AuditLogBusiness().AddLoginAuditLog(IsAuthenticatedUser, LoginReturnValue.SessionId, UserName, Password); } catch (System.Exception Ex) { LoginReturnValue.ReturnCode = -1; LoginReturnValue.IsValidUser = false; LoginReturnValue.ReturnMessage = "Login UnSuccessful - Error in API"; SICTLogger.WriteException(UserDetailsBusiness.CLASS_NAME, "Authenticate ", Ex); } SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "Authenticate ", "End "); return(LoginReturnValue); }
public Logger(LoggerOptions loggerOptions) { LoggerOptions = loggerOptions; DAL = new DataAccessLayer.DataAccessLayer(loggerOptions.ConnectionOptions); }
public ResponseUserDetail GetAllUser() { ResponseUserDetail ResponseUserDetail = new ResponseUserDetail(); SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "GetAllUser", "Start "); try { DataAccessLayer.DataAccessLayer DBLayer = new DataAccessLayer.DataAccessLayer(); SICTLogger.WriteVerbose(UserDetailsBusiness.CLASS_NAME, "GetAllUser", "Retrieving All User Details from DB Start"); DataTable DtUser = DBLayer.GetAllUseDetails(); System.Collections.Generic.List <UserDetail> UserDetails = new System.Collections.Generic.List <UserDetail>(); foreach (DataRow Dr in DtUser.Rows) { UserDetail TempUserDetails = new UserDetail(); if (!string.IsNullOrEmpty(Dr[BusinessConstants.USER_USERID].ToString())) { TempUserDetails.UserId = System.Convert.ToInt32(Dr[BusinessConstants.USER_USERID].ToString()); } else { TempUserDetails.UserId = -1; } TempUserDetails.IsLogin = System.Convert.ToBoolean(Dr[BusinessConstants.USER_ISLOGIN].ToString()); if (!string.IsNullOrEmpty(Dr[BusinessConstants.USER_USERNAME].ToString())) { TempUserDetails.UserName = Dr[BusinessConstants.USER_USERNAME].ToString(); } if (!string.IsNullOrEmpty(Dr[BusinessConstants.USER_PASSWORD].ToString())) { TempUserDetails.Password = Dr[BusinessConstants.USER_PASSWORD].ToString(); } if (!string.IsNullOrEmpty(Dr[BusinessConstants.AIRPORTID].ToString())) { TempUserDetails.AirportId = System.Convert.ToInt32(Dr[BusinessConstants.AIRPORTID].ToString()); } if (!string.IsNullOrEmpty(Dr[BusinessConstants.USER_AIRPORTNAME].ToString())) { string AirportName = Dr[BusinessConstants.USER_AIRPORTNAME].ToString(); int Index = AirportName.LastIndexOf('('); if (Index > 0) { AirportName = AirportName.Remove(AirportName.LastIndexOf('(')); } AirportName = AirportName.Trim(); TempUserDetails.AirportName = AirportName; } if (!string.IsNullOrEmpty(Dr[BusinessConstants.USER_ISACTIVE].ToString())) { TempUserDetails.IsActive = System.Convert.ToBoolean(Dr[BusinessConstants.USER_ISACTIVE].ToString()); } if (!string.IsNullOrEmpty(Dr[BusinessConstants.USER_DEPARTUREFORMACCESS].ToString())) { TempUserDetails.DepartureFormAccess = System.Convert.ToBoolean(Dr[BusinessConstants.USER_DEPARTUREFORMACCESS].ToString()); } if (!string.IsNullOrEmpty(Dr[BusinessConstants.USER_ARRIVALFORMACCESS].ToString())) { TempUserDetails.ArrivalFormAccess = System.Convert.ToBoolean(Dr[BusinessConstants.USER_ARRIVALFORMACCESS].ToString()); } if (!string.IsNullOrEmpty(Dr[BusinessConstants.USER_ROLE].ToString())) { TempUserDetails.RoleId = System.Convert.ToInt32(Dr[BusinessConstants.USER_ROLE].ToString()); } UserDetails.Add(TempUserDetails); } ResponseUserDetail.UserDetails = UserDetails; ResponseUserDetail.ReturnCode = 1; ResponseUserDetail.ReturnMessage = "Retrieved Successfully"; } catch (System.Exception Ex) { SICTLogger.WriteException(UserDetailsBusiness.CLASS_NAME, "GetAllUser", Ex); ResponseUserDetail.ReturnCode = -1; ResponseUserDetail.ReturnMessage = "Error in API"; } SICTLogger.WriteInfo(UserDetailsBusiness.CLASS_NAME, "GetAllUser", "End"); return(ResponseUserDetail); }
private void InsertFormFilterstoWorkBook(ref Worksheet DataSheet, DepartureFormFilterDetails DepartureFormFilterDetails) { DataAccessLayer.DataAccessLayer DBLayer = new DataAccessLayer.DataAccessLayer(); try { int HeaderRow = 0; int HeaderCol = 0; this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_ID); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_AIRPORT_ID); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 14, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_DATE); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_INTERVIEWER_ID); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_AIRLINES_ID); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_DEPTARR); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_DEPT_ID); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_FLIGHT_NUMBER); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_LANG1); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_STARTCODE1); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_ENDCODE1); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_LANG2); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_STARTCODE2); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_ENDCODE2); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_LANG3); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_STARTCODE3); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_ENDCODE3); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_LANG4); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_STARTCODE4); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_ENDCODE4); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_LANG5); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_STARTCODE5); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_ENDCODE5); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_BUSS_CLASS); this.SetExcelCellStyle(ref DataSheet, HeaderRow, HeaderCol, 12, System.Drawing.Color.White, false, false, 22, false); DataSheet.Cells[HeaderRow, HeaderCol++].PutValue(BusinessConstants.FORM_DOWNLOAD_CHANGE_TIME); } catch (System.Exception Ex) { SICTLogger.WriteException(DownloadBusiness.CLASS_NAME, "InsertFormFilterstoWorkBook", Ex); } }
public Logger(LoggingOptions options, IParser parser) { logOptions = options; dal = new DataAccessLayer.DataAccessLayer(logOptions.ConnectionOptions, parser); }
public static void InitialiseDBConnection(string DatabasePath) { DatabaseInst = new DataAccessLayer.DatabaseLayer(DatabasePath); ProcessingInst = new ProcessingLayer.ProcessingLayer(DatabaseInst); DataAccessInst = new DataAccessLayer.DataAccessLayer(); }