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();
}
