public void SaveError(string ErrorMessage, string Source, string Class, string Method, string EventId, string StackTrace)
{
string user = new AuthorizationManager.AuthorizationManager().getLoggedInUser();
SqlConnection objConnection = null;
SqlCommand objCommand = null;
string ConnStr = string.Empty;
try
{
ConnStr = DBConstants.GetDBConnectionString();
objConnection = new SqlConnection(ConnStr);
objConnection.Open();
objCommand = new SqlCommand(SPNames.InsertError, objConnection);
objCommand.CommandType = CommandType.StoredProcedure;
SqlParameter[] sqlParam = new SqlParameter[7];
sqlParam[0] = objCommand.Parameters.AddWithValue("@ErrorMessage", ErrorMessage);
sqlParam[1] = objCommand.Parameters.AddWithValue("@Source", Source);
sqlParam[2] = objCommand.Parameters.AddWithValue("@Class", Class);
sqlParam[3] = objCommand.Parameters.AddWithValue("@Method", Method);
sqlParam[4] = objCommand.Parameters.AddWithValue("@EventId", EventId);
sqlParam[5] = objCommand.Parameters.AddWithValue("@StackTrace", StackTrace);
sqlParam[6] = objCommand.Parameters.AddWithValue("@CreatedById", user);
int result = objCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
//throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, "Projects.cs", "UpdateProject", EventIDConstants.RAVE_HR_PROJECTS_DATA_ACCESS_LAYER);
}
finally
{
if (objConnection.State == ConnectionState.Open)
{
objConnection.Close();
}
}
}
///// <summary>
///// Function will fill all the dropdowns
///// </summary>
///// <param name="category"></param>
///// <returns>Collection</returns>
//public BusinessEntities.RaveHRCollection FillDropDownsDL(int categoryId)
//{
// //Declare DataAccess Class Object
// objDA = new DataAccessClass();
// SqlParameter[] sqlParam = new SqlParameter[1];
// try
// {
// BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection();
// objDA.OpenConnection(DBConstants.GetDBConnectionString());
// sqlParam[0] = new SqlParameter(SPParameter.Category, SqlDbType.Int);
// sqlParam[0].Value = categoryId;
// objReader = objDA.ExecuteReaderSP(SPNames.Master_GetMasterData, sqlParam);
// while (objReader.Read())
// {
// if (objReader.GetValue(1).ToString() != "Abort")
// {
// KeyValue<string> keyValue = new KeyValue<string>();
// keyValue.KeyName = objReader.GetValue(0).ToString();
// keyValue.Val = objReader.GetValue(1).ToString();
// raveHRCollection.Add(keyValue);
// }
// }
// return raveHRCollection;
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// if (objReader != null)
// {
// objReader.Close();
// }
// objDA.CloseConncetion();
// }
//}
////Siddhesh Arekar Issue ID : 55884 Closure Type
///// <summary>
///// Get Master Type Details
///// </summary>
///// <param name="category"></param>
///// <returns>string</returns>
//public KeyValue<string> GetMasterTypeDetails(int categoryId, string key)
//{
// //Declare DataAccess Class Object
// objDA = new DataAccessClass();
// SqlParameter[] sqlParam = new SqlParameter[1];
// try
// {
// BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection();
// objDA.OpenConnection(DBConstants.GetDBConnectionString());
// sqlParam[0] = new SqlParameter(SPParameter.Category, SqlDbType.Int);
// sqlParam[0].Value = categoryId;
// objReader = objDA.ExecuteReaderSP(SPNames.Master_GetMasterData, sqlParam);
// KeyValue<string> keyValue = new KeyValue<string>();
// while (objReader.Read())
// {
// if (objReader.GetValue(1).ToString() != "Abort")
// {
// if (Convert.ToString(objReader.GetValue(1)) == key)
// {
// keyValue.KeyName = objReader.GetValue(0).ToString();
// keyValue.Val = objReader.GetValue(1).ToString();
// break;
// }
// }
// }
// return keyValue;
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// if (objReader != null)
// {
// objReader.Close();
// }
// objDA.CloseConncetion();
// }
//}
////Siddhesh Arekar Issue ID : 55884 Closure Type
//public BusinessEntities.RaveHRCollection FillDepartmentDropDownDL()
//{
// objDA = new DataAccessClass();
// try
// {
// BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection();
// objDA.OpenConnection(DBConstants.GetDBConnectionString());
// objReader = objDA.ExecuteReaderSP(SPNames.Master_GetDepartment);
// while (objReader.Read())
// {
// KeyValue<string> keyValue = new KeyValue<string>();
// keyValue.KeyName = objReader.GetValue(0).ToString();
// keyValue.Val = objReader.GetValue(1).ToString();
// raveHRCollection.Add(keyValue);
// }
// return raveHRCollection;
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// if (objReader != null)
// {
// objReader.Close();
// }
// objDA.CloseConncetion();
// }
//}
//#region Modified By Mohamed Dangra
//// Mohamed : NIS-RMS : 29/12/2014 : Starts
//// Desc : Show Departement for which the person is eligible
//public BusinessEntities.RaveHRCollection FillEligibleDepartmentDropDownDL(string strCurrentUser)
//{
// objDA = new DataAccessClass();
// try
// {
// BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection();
// objDA.OpenConnection(DBConstants.GetDBConnectionString());
// SqlParameter[] sqlParam = new SqlParameter[1];
// sqlParam[0] = new SqlParameter(SPParameter.EmailId, DbType.String);
// sqlParam[0].Value = strCurrentUser;
// objReader = objDA.ExecuteReaderSP(SPNames.MRF_GetMRFRaiseAccesForDepartmentByEmpId, sqlParam);
// while (objReader.Read())
// {
// KeyValue<string> keyValue = new KeyValue<string>();
// keyValue.KeyName = objReader.GetValue(0).ToString();
// keyValue.Val = objReader.GetValue(1).ToString();
// raveHRCollection.Add(keyValue);
// }
// return raveHRCollection;
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// if (objReader != null)
// {
// objReader.Close();
// }
// objDA.CloseConncetion();
// }
//}
//// Mohamed : : 29/12/2014 : Ends
//#endregion Modified By Mohamed Dangra
///// <summary>
///// Added by Kanchan for the requirment specified in the Discussion with Sawita Kamath and Gaurav Thakkar.
///// Requirment raised:
///// Gives the emailId for the employee whose Employee id is supplied.
///// </summary>
///// <param name="empId"></param>
///// <returns></returns>
//public string getEmployeeEmailID(int empId)
//{
// DataAccessClass objDAForMaster = new DataAccessClass();
// SqlParameter[] sqlParam = new SqlParameter[1];
// BusinessEntities.MRFDetail mrfDetail = new MRFDetail();
// string emailID = string.Empty;
// DataSet empDetail = new DataSet();
// try
// {
// //Opens the connection.
// objDAForMaster.OpenConnection(DBConstants.GetDBConnectionString());
// sqlParam[0] = new SqlParameter(SPParameter.EmpId, DbType.Int32);
// sqlParam[0].Value = empId;
// empDetail = objDAForMaster.GetDataSet(SPNames.Contract_EmpEmailID, sqlParam);
// foreach (DataRow dr in empDetail.Tables[0].Rows)
// {
// emailID = dr[DbTableColumn.EmailId].ToString();
// }
// return emailID;
// }
// catch (RaveHRException ex)
// {
// throw ex;
// }
// catch (Exception ex)
// {
// throw new RaveHRException(ex.Message, ex, Sources.DataAccessLayer, "Master", "getEmployeeEmailID", EventIDConstants.RAVE_HR_MASTER_DATA_ACCESS_LAYER);
// }
// finally
// {
// objDAForMaster.CloseConncetion();
// }
//}
///// <summary>
///// Get_s the client abbrivation.
///// </summary>
///// <param name="MasterId">The master id.</param>
///// <returns></returns>
//public string Get_ClientAbbrivation(int MasterId)
//{
// //Initialise Data Access Class object
// objDA = new DataAccessClass();
// //Initialise SqlParameter Class object
// SqlParameter[] sqlParam = new SqlParameter[1];
// string sname = string.Empty;
// SqlDataReader objDataReader;
// try
// {
// //Open the connection to DB
// objDA.OpenConnection(DBConstants.GetDBConnectionString());
// //Check each parameters nullibality and add values to sqlParam object accordingly
// sqlParam[0] = new SqlParameter(SPParameter.MasterId, SqlDbType.Int);
// if (MasterId == 0)
// sqlParam[0].Value = DBNull.Value;
// else
// sqlParam[0].Value = MasterId;
// objDataReader = objDA.ExecuteReaderSP(SPNames.Contracts_GetClientAbbrivation, sqlParam);
// while (objDataReader.Read())
// {
// sname = objDataReader[DbTableColumn.Con_Details].ToString();
// }
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// if (objReader != null)
// {
// objReader.Close();
// objDA.CloseConncetion();
// }
// }
// return sname;
//}
////Ishwar Patil : Trainging Module 29/04/2014 : Starts
///// <summary>
///// this function fills the dropdown
///// </summary>
//public DataTable FillTraining_DropDownList(string strCategory)
//{
// try
// {
// string ConnStr = DBConstants.GetDBConnectionString();
// objConnection = new SqlConnection(ConnStr);
// objConnection.Open();
// objCommand = new SqlCommand(SPNames.TNI_GetMasterSP, objConnection);
// objCommand.CommandType = CommandType.StoredProcedure;
// objCommand.Parameters.Add("@Category", strCategory);
// objReader = objCommand.ExecuteReader();
// DataTable objDataTable = new DataTable();
// objDataTable.Load(objReader);
// return objDataTable;
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// if (objReader != null)
// {
// objReader.Close();
// }
// if (objConnection.State == ConnectionState.Open)
// {
// objConnection.Close();
// }
// }
//}
////Ishwar Patil : Trainging Module 29/04/2014 : End
///// <summary>
///// Get Client Name
///// </summary>
///// <returns>DataSet</returns>
//public BusinessEntities.RaveHRCollection GetClientNameDL()
//{
// objDA = new DataAccessClass();
// try
// {
// BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection();
// objDA.OpenConnection(DBConstants.GetDBConnectionString());
// objReader = objDA.ExecuteReaderSP(SPNames.Contracts_GetClientName);
// while (objReader.Read())
// {
// KeyValue<string> keyValue = new KeyValue<string>();
// keyValue.KeyName = objReader.GetValue(0).ToString();
// keyValue.Val = objReader.GetValue(1).ToString();
// raveHRCollection.Add(keyValue);
// }
// return raveHRCollection;
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// if (objReader != null)
// {
// objReader.Close();
// }
// objDA.CloseConncetion();
// }
//}
//// Ishwar NISRMS 13032015 Start
//public BusinessEntities.RaveHRCollection FillDropDownsDLForStatus(int categoryId)
//{
// //Declare DataAccess Class Object
// objDA = new DataAccessClass();
// SqlParameter[] sqlParam = new SqlParameter[1];
// try
// {
// BusinessEntities.RaveHRCollection raveHRCollection = new BusinessEntities.RaveHRCollection();
// objDA.OpenConnection(DBConstants.GetDBConnectionString());
// sqlParam[0] = new SqlParameter(SPParameter.Category, SqlDbType.Int);
// sqlParam[0].Value = categoryId;
// objReader = objDA.ExecuteReaderSP(SPNames.Master_GetMasterDataForStatus, sqlParam);
// while (objReader.Read())
// {
// if (objReader.GetValue(1).ToString() != "Abort")
// {
// KeyValue<string> keyValue = new KeyValue<string>();
// keyValue.KeyName = objReader.GetValue(0).ToString();
// keyValue.Val = objReader.GetValue(1).ToString();
// raveHRCollection.Add(keyValue);
// }
// }
// return raveHRCollection;
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// if (objReader != null)
// {
// objReader.Close();
// }
// objDA.CloseConncetion();
// }
//}
//// Ishwar NISRMS 13032015 End
public int GetEmployeeIDByEmailID()
{
AuthorizationManager.AuthorizationManager authoriseduser = new AuthorizationManager.AuthorizationManager();
return(GetEmployeeID(authoriseduser.getLoggedInUserEmailId()));
}
