//User Logs
public string InsertUpdateEmployeeLogs(EmployeeLogs EmployeeLogsBO, out string error)
{
Exception exError;
LoginBL Bl = new LoginBL();
string val = Bl.InsertUpdateEmployeeLogs(EmployeeLogsBO, out exError);
error = exError == null ? "" : exError.Message;
return(val);
}
public string InsertUpdateEmployeeLogs(EmployeeLogs EmployeeLogsBO, out Exception error)
{
try
{
LoginDAL dal = new LoginDAL();
if (EmployeeLogsBO.EmployeeID == 0)
{
EmployeeLogsBO.EmployeeID = Convert.ToInt32(HttpContext.Current.Session["userid"]);
}
return(dal.InsertUpdateEmployeeLogs(EmployeeLogsBO, Constants.SpUserLogs, out error));
}
catch (Exception)
{
throw;
}
}
//User Logs when Logs Out
public void InsertUpdateEmployeeLogs(int LoginUserID, int EmployeeLogID, int StatusID)
{
Exception exError;
LoginBL Bl = new LoginBL();
EmployeeLogs EmployeeLogsBO = new EmployeeLogs();
EmployeeLogsBO.StatusID = StatusID;
EmployeeLogsBO.LoggedOutTime = DateTime.Now;
EmployeeLogsBO.LastAccessedTime = DateTime.Now;
EmployeeLogsBO.UserLogin = "";
EmployeeLogsBO.EmployeeID = LoginUserID;
EmployeeLogsBO.EmployeeLogID = EmployeeLogID;
string val = Bl.InsertUpdateEmployeeLogs(EmployeeLogsBO, out exError);
val = exError == null ? val : exError.Message;
}
public string InsertUpdateEmployeeLogs(EmployeeLogs EmployeeLogsBO, string _commandText, out Exception error)
{
string Output = string.Empty;
string hostName = Dns.GetHostName(); // Retrive the Name of HOST
// Get the IP
string myIP = Dns.GetHostByName(hostName).AddressList[0].ToString();
try
{
error = null;
try
{
using (DbCommand command = _db.GetStoredProcCommand(_commandText))
{
using (DbConnection connection = _db.CreateConnection())
{
connection.Open();
command.Connection = connection;
EmployeeLogsBO.IPAddress = myIP;
var parameter = command.CreateParameter();
parameter.ParameterName = "@UserLoginID";
parameter.Value = EmployeeLogsBO.EmployeeID;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@EmployeeLogID";
parameter.Value = EmployeeLogsBO.EmployeeLogID;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@LoggedInTime";
parameter.Value = EmployeeLogsBO.LoggedInTime;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@LoggedOutTime";
parameter.Value = EmployeeLogsBO.LoggedOutTime;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@LastAccessedTime";
parameter.Value = EmployeeLogsBO.LastAccessedTime;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@IPAddress";
parameter.Value = EmployeeLogsBO.IPAddress;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@MessageLog";
parameter.Value = EmployeeLogsBO.MessageLog;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@LoggedOutBy";
parameter.Value = EmployeeLogsBO.LoggedOutBy;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@StatusID";
parameter.Value = EmployeeLogsBO.StatusID;
command.Parameters.Add(parameter);
Output = command.ExecuteScalar().ToString();
connection.Close();
}
}
}
catch (InvalidOperationException invalid)
{
error = invalid;
Output = "failed";
}
catch (Exception ex)
{
error = ex;
Output = "failed";
}
return(Output);
}
catch (Exception)
{
throw;
}
}