public DataSet GetEmployeeShiftDetail(RosterPlanningModel objRosterPlanningModel) { try { SqlParameter[] objParam = new SqlParameter[3]; //objParam[0] = new SqlParameter("@EmployeeID", DbType.Int32); objParam[0] = new SqlParameter("@UserID", DbType.Int32); objParam[0].Value = objRosterPlanningModel.UserId; objParam[1] = new SqlParameter("@FromDate", DbType.DateTime); objParam[1].Value = objRosterPlanningModel.FromDate; objParam[2] = new SqlParameter("@ToDate", DbType.DateTime); objParam[2].Value = objRosterPlanningModel.ToDate; dsRosterPlanningDAL = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "GetEmployeeShiftDetail", objParam); return(dsRosterPlanningDAL); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "RosterPlanningDAL.cs", "GetEmployeeShiftDetail", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public DataSet GetRosterDataReport(RosterPlanningModel objRosterPlanningModel) { try { SqlParameter[] objParam = new SqlParameter[5]; objParam[0] = new SqlParameter("@UserID", objRosterPlanningModel.UserId); objParam[1] = new SqlParameter("@ShiftID", objRosterPlanningModel.ShiftID); objParam[2] = new SqlParameter("@StartDate", objRosterPlanningModel.FromDate); objParam[3] = new SqlParameter("@EndDate", objRosterPlanningModel.ToDate); objParam[4] = new SqlParameter("@LoggedUserId", objRosterPlanningModel.LoggedUserId); dsRosterPlanningDAL = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "GetRosterDataReport", objParam); return(dsRosterPlanningDAL); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "RosterPlanningDAL.cs", "GetRosterDataReport", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public DataSet GetEmployeeRole(RosterPlanningModel objRosterPlanningModel) { string V2toolsDBEntity = ""; V2toolsDBEntity = ConfigurationManager.AppSettings["V2toolsDBEntity"].ToString(); try { SqlParameter[] objParam = new SqlParameter[2]; objParam[0] = new SqlParameter("@ApplicationName", DbType.String); objParam[0].Value = "V2ToolsApp"; objParam[1] = new SqlParameter("@UserName", DbType.String); objParam[1].Value = objRosterPlanningModel.UserId; dsRosterPlanningDAL = SqlHelper.ExecuteDataset(V2toolsDBEntity, CommandType.StoredProcedure, "aspnet_UsersInRoles_GetRolesForUser", objParam); return(dsRosterPlanningDAL); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "RosterPlanningDAL.cs", "GetEmployeeRole", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public void InsertEmployeeeShiftDetails(RosterPlanningModel objRosterPlanningModel) { try { SqlParameter[] objParam = new SqlParameter[6]; objParam[0] = new SqlParameter("@UserID", objRosterPlanningModel.UserId); objParam[1] = new SqlParameter("@ShiftId", objRosterPlanningModel.ShiftID); objParam[2] = new SqlParameter("@WeekOff1", objRosterPlanningModel.WeekOffDate1); objParam[3] = new SqlParameter("@WeekOff2", objRosterPlanningModel.WeekOffDate2); objParam[4] = new SqlParameter("@StartDate", objRosterPlanningModel.FromDate); objParam[5] = new SqlParameter("@EndDate", objRosterPlanningModel.ToDate); SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "sp_Insert_Update_EmployeeShiftDetail", objParam); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "RosterPlanningDAL.cs", "sp_Insert_Update_EmployeeShiftDetail", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public void InsertEmployeeeShiftDetails(RosterPlanningModel objRosterPlanningModel) { try { objRosterPlanningDAL.InsertEmployeeeShiftDetails(objRosterPlanningModel); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "RosterPlanningBOL.cs", "sp_Insert_Update_EmployeeShiftDetail", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public DataSet GetEmployeeShiftDetail(RosterPlanningModel objRosterPlanningModel) { try { return(objRosterPlanningDAL.GetEmployeeShiftDetail(objRosterPlanningModel)); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "RosterPlanningBOL.cs", "sp_FillShiftData", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }
public DataSet GetRosterDataReport(RosterPlanningModel objRosterPlanningModel) { try { dsRosterPlanningBOL = objRosterPlanningDAL.GetRosterDataReport(objRosterPlanningModel); return(dsRosterPlanningBOL); } catch (V2Exceptions ex) { throw; } catch (System.Exception ex) { FileLog objFileLog = FileLog.GetLogger(); objFileLog.WriteLine(LogType.Error, ex.Message, "RosterPlanningBOL.cs", "GetRosterData", ex.StackTrace); throw new V2Exceptions(ex.ToString(), ex); } }