// GET: Notice Board General Informations
public ActionResult GeneralInformation()
{
int BlockSize = 10;
NoticeBoardModel noticeBoardModel = new NoticeBoardModel();
noticeBoardModel.GeneralInformationModelList = noticeBoardHelper.GetAllGeneralInformation(1, BlockSize, string.Empty);
return(View(noticeBoardModel));
}
// GET: Notice Board Latest Alerts
public ActionResult Index()
{
int BlockSize = 10;
NoticeBoardModel noticeBoardModel = new NoticeBoardModel();
noticeBoardModel.AlertAndNotificationModelList = noticeBoardHelper.GetAllAlertAndNotification(1, BlockSize);
return(View(noticeBoardModel));
}
// GET: Notice Board meetings Schedule
public ActionResult MeetingSchedule()
{
int BlockSize = 10;
NoticeBoardModel noticeBoardModel = new NoticeBoardModel();
noticeBoardModel.ScheduleMeetingModelList = noticeBoardHelper.GetAllScheduleMeeting(1, BlockSize);
return(View(noticeBoardModel));
}
public NoticeBoardModel GetLatestReport(NoticeBoardModel objNoticeBoardModel)
{
string vQuery = "SELECT " +
"rownum sl, " +
"NOTICE_ID, " +
"TO_CHAR (NVL (NOTICE_TITLE,'N/A'))NOTICE_TITLE, " +
"NOTICE_TYPE_ID, " +
"NOTICE_TYPE_NAME, " +
"TO_CHAR(NOTICE_DATE, 'dd/mm/yyyy') NOTICE_DATE, " +
"FILE_NAME, " +
"FILE_SIZE " +
"FROM VEW_LATEST_NOTICE where head_office_id = '" + objNoticeBoardModel.HeadOfficeId + "' AND branch_office_id = '" + objNoticeBoardModel.BranchOfficeId + "' ";
//if (!string.IsNullOrWhiteSpace(objNoticeBoardModel.FromDate) && !string.IsNullOrWhiteSpace(objNoticeBoardModel.ToDate))
//{
// vQuery = vQuery + " and notice_date between to_date('" + objNoticeBoardModel.FromDate + "', 'dd/mm/yyyy') and to_date('" + objNoticeBoardModel.ToDate + "', 'dd/mm/yyyy') ";
//}
//vQuery = vQuery + " ORDER BY NOTICE_DATE desc";
using (OracleConnection objConnection = GetConnection())
{
OracleCommand objCommand = new OracleCommand(vQuery, objConnection);
objConnection.Open();
OracleDataReader objDataReader = objCommand.ExecuteReader();
try
{
if (objDataReader.HasRows)
{
objDataReader.Read();
//string vFileName = objDataReader["FILE_NAME"].ToString();
objNoticeBoardModel = new NoticeBoardModel
{
//NoticeBoardImageModel = new NoticeBoardImageModel
//{
// FileSize = objDataReader["FILE_SIZE"].ToString()
//}
bytes = (byte[])objDataReader["FILE_SIZE"]
};
}
}
catch (Exception ex)
{
throw new Exception("Error : " + ex.Message);
}
finally
{
objDataReader.Close();
objConnection.Close();
}
}
return(objNoticeBoardModel);
}
// GET: Notice Board meetings Schedule
public ActionResult MaintenanceSchedule()
{
int BlockSize = 10;
NoticeBoardModel noticeBoardModel = new NoticeBoardModel();
noticeBoardModel.MaintenanceScheduleModelList = noticeBoardHelper.GetAllMaintenanceSchedule(1, BlockSize);
ViewBag.CommonAreaList = CommonData.GetCommonAreaList(ClientSessionData.ClientStrataBoardId);
return(View(noticeBoardModel));
}
// GET: NoticeBoard
public ActionResult Index()
{
// was gibt es neues
var advs = Db.Advertisements.ToList();
var model = new NoticeBoardModel
{
Advertisements = advs
};
return(View(model));
}
private NoticeBoardModel GenerateNoticeBoardObject(string companyCode, string msgCode, string msgTitle, string msgBody, string hyperlink, string priority,
string validFrom, string validTo, string distType, string ackReqd, string fileName, string selectedNodeValues, string showTicker, string highlight)
{
try
{
List <NoticeBoardAgent> lstNotoceBoardAgent = new List <NoticeBoardAgent>();
NoticeBoardModel objNoticeBoardModel = new NoticeBoardModel();
NoticeBoardAgent objNoticeBoardAgent = new NoticeBoardAgent();
validFrom = validFrom.Split('/')[2] + "-" + validFrom.Split('/')[1] + "-" + validFrom.Split('/')[0];
validTo = validTo.Split('/')[2] + "-" + validTo.Split('/')[1] + "-" + validTo.Split('/')[0];
objNoticeBoardModel.MsgCode = msgCode;
objNoticeBoardModel.MsgTitle = msgTitle;
objNoticeBoardModel.MsgBody = msgBody;
objNoticeBoardModel.MsgHyperlink = hyperlink;
objNoticeBoardModel.MsgPriority = Convert.ToInt16(priority);
objNoticeBoardModel.MsgValidFrom = validFrom;
objNoticeBoardModel.MsgValidTo = validTo;
objNoticeBoardModel.MsgSenderUserCode = _objCurrentInfo.GetUserCode();
objNoticeBoardModel.MsgDistributionType = Convert.ToChar(distType);
objNoticeBoardModel.MsgAcknowlendgementReqd = Convert.ToChar(ackReqd);
objNoticeBoardModel.MsgAttachmentPath = fileName;
objNoticeBoardModel.SHOW_IN_TICKER_ONLY = showTicker;
objNoticeBoardModel.HIGHLIGHT = highlight;
if (distType.Trim().ToUpper() == "M") // M means "My Team". Since I'm sending a notice to my team, approval is not required
{
objNoticeBoardModel.MsgApprovalStatus = 'Y'; // 'Y' means Yes. (i.e.) Msg will be saved in approved status by default.
}
else
{
objNoticeBoardModel.MsgApprovalStatus = 'N';
}
string[] targetUserCodes;
if (distType.Trim().ToUpper() == "R")
{
targetUserCodes = GetUserCodes(companyCode, selectedNodeValues);
}
else
{
targetUserCodes = selectedNodeValues.Split(',');
}
foreach (string userCode in targetUserCodes)
{
if (!string.IsNullOrEmpty(userCode))
{
objNoticeBoardAgent = new NoticeBoardAgent();
objNoticeBoardAgent.MsgCode = msgCode;
objNoticeBoardAgent.MsgTargetUserCode = userCode;
lstNotoceBoardAgent.Add(objNoticeBoardAgent);
}
}
objNoticeBoardModel.lstNoticeBoardAgent = lstNotoceBoardAgent;
return(objNoticeBoardModel);
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
dicContext.Add("InputParameter(s):companyCode", companyCode);
dicContext.Add("InputParameter(s):msgCode", msgCode);
dicContext.Add("InputParameter(s):msgTitle", msgTitle);
dicContext.Add("InputParameter(s):msgBody", msgBody);
dicContext.Add("InputParameter(s):hyperlink", hyperlink);
dicContext.Add("InputParameter(s):priority", priority);
dicContext.Add("InputParameter(s):validFrom", validFrom);
dicContext.Add("InputParameter(s):distType", distType);
dicContext.Add("InputParameter(s):ackReqd", ackReqd);
dicContext.Add("InputParameter(s):fileName", fileName);
dicContext.Add("InputParameter(s):selectedNodeValues", selectedNodeValues);
dicContext.Add("Method:", MethodBase.GetCurrentMethod().Name);
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
throw ex;
}
}
public NoticeBoardModel GetNoticeById(NoticeBoardModel objNoticeBoardModel)
{
string vQuery = "SELECT " +
"rownum sl, " +
"NOTICE_ID, " +
"NOTICE_TITLE, " +
"NOTICE_TYPE_ID, " +
"NOTICE_TYPE_NAME, " +
"TO_CHAR(NOTICE_DATE, 'dd/mm/yyyy') NOTICE_DATE, " +
"FILE_NAME, " +
"FILE_SIZE, " +
"FILE_EXTENSION " +
" FROM VEW_NOTICE_BOARD_UPLOAD where head_office_id = '" + objNoticeBoardModel.HeadOfficeId + "' AND branch_office_id = '" + objNoticeBoardModel.BranchOfficeId + "' ";
//"FROM VEW_BILL_OF_MATERIAL_SUB WHERE HEAD_OFFICE_ID = '" + objTrimsModel.HeadOfficeId + "' AND BRANCH_OFFICE_ID = '" + objTrimsModel.BranchOfficeId + "' ";
if (!string.IsNullOrEmpty(objNoticeBoardModel.NoticeId))
{
vQuery = vQuery + "and NOTICE_ID = '" + objNoticeBoardModel.NoticeId + "'";
}
if (!string.IsNullOrEmpty(objNoticeBoardModel.NoticeDate))
{
vQuery = vQuery + "and NOTICE_DATE = TO_DATE('" + objNoticeBoardModel.NoticeDate + "', 'dd/mm/yyyy')";
}
if (!string.IsNullOrEmpty(objNoticeBoardModel.NoticeTypeId))
{
vQuery = vQuery + "and NOTICE_TYPE_ID = '" + objNoticeBoardModel.NoticeTypeId + "'";
}
vQuery = vQuery + " ORDER BY NOTICE_DATE desc";
using (OracleConnection objConnection = GetConnection())
{
OracleCommand objCommand = new OracleCommand(vQuery, objConnection);
objConnection.Open();
OracleDataReader objDataReader = objCommand.ExecuteReader();
try
{
if (objDataReader.HasRows)
{
objDataReader.Read();
objNoticeBoardModel.NoticeBoardImageModel = new NoticeBoardImageModel();
// objNoticeBoardImageModel = new NoticeBoardImageModel();
objNoticeBoardModel.SerialNumber = objDataReader.GetInt32(0).ToString();
objNoticeBoardModel.NoticeId = objDataReader.GetValue(1).ToString();
objNoticeBoardModel.NoticeTitle = objDataReader.GetValue(2).ToString();
objNoticeBoardModel.NoticeTypeId = objDataReader.GetValue(3).ToString();
//objNoticeBoardImageModel.NoticeBoardModel.NoticeTypeName = objDataReader.GetString(4).ToString();
objNoticeBoardModel.NoticeDate = objDataReader.GetValue(5).ToString();
objNoticeBoardModel.NoticeBoardImageModel.FileName = objDataReader.GetValue(6).ToString();
objNoticeBoardModel.NoticeBoardImageModel.FileExtension = objDataReader.GetValue(8).ToString();
objNoticeBoardModel.NoticeBoardImageModel.fileBytes = (byte[])objDataReader.GetValue(7);
//objNoticeBoardImageModel.FabricUnitId = objDataReader.GetInt32(6).ToString();
}
}
catch (Exception ex)
{
throw new Exception("Error : " + ex.Message);
}
finally
{
objDataReader.Close();
objConnection.Close();
}
}
return(objNoticeBoardModel);
}
//NOTICE BOARD FOR ALL
public DataTable NoticeFileForAll(NoticeBoardModel objNoticeBoardModel)
{
//Master
DataTable objDataTable = new DataTable();
string vQuery = "SELECT " +
"rownum sl, " +
"NOTICE_ID, " +
"TO_CHAR (NVL (NOTICE_TITLE,'N/A'))NOTICE_TITLE, " +
"NOTICE_TYPE_ID, " +
"NOTICE_TYPE_NAME, " +
"TO_CHAR(NOTICE_DATE, 'dd/mm/yyyy') NOTICE_DATE, " +
"FILE_NAME " +
"FROM VEW_NOTICE_BOARD_UPLOAD where head_office_id = '" + objNoticeBoardModel.HeadOfficeId + "' AND branch_office_id = '" + objNoticeBoardModel.BranchOfficeId + "' ";
//vQuery = "SELECT * FROM VEW_NOTICE_BOARD_UPLOAD where head_office_id = '" + objNoticeBoardModel.HeadOfficeId + "' AND branch_office_id = '" + objNoticeBoardModel.BranchOfficeId + "' ";
//"FROM VEW_BILL_OF_MATERIAL_MAIN WHERE HEAD_OFFICE_ID = '" + objTrimsModel.HeadOfficeId + "' AND BRANCH_OFFICE_ID = '" + objTrimsModel.BranchOfficeId + "' ";
if (!string.IsNullOrWhiteSpace(objNoticeBoardModel.FromDate) && !string.IsNullOrWhiteSpace(objNoticeBoardModel.ToDate))
{
vQuery = vQuery + " and notice_date between to_date('" + objNoticeBoardModel.FromDate + "', 'dd/mm/yyyy') and to_date('" + objNoticeBoardModel.ToDate + "', 'dd/mm/yyyy') ";
}
if (!string.IsNullOrWhiteSpace(objNoticeBoardModel.btnAll))
{
vQuery = vQuery + " and NOTICE_TYPE_ID ='" + objNoticeBoardModel.btnAll + "' ";
}
if (!string.IsNullOrWhiteSpace(objNoticeBoardModel.btnBonusPoint))
{
vQuery = vQuery + " and NOTICE_TYPE_ID ='" + objNoticeBoardModel.btnBonusPoint + "' ";
}
if (!string.IsNullOrWhiteSpace(objNoticeBoardModel.btnHoliday))
{
vQuery = vQuery + " and NOTICE_TYPE_ID ='" + objNoticeBoardModel.btnHoliday + "' ";
}
if (!string.IsNullOrWhiteSpace(objNoticeBoardModel.btnIdCard))
{
vQuery = vQuery + " and NOTICE_TYPE_ID ='" + objNoticeBoardModel.btnIdCard + "' ";
}
if (!string.IsNullOrWhiteSpace(objNoticeBoardModel.btnKPI))
{
vQuery = vQuery + " and NOTICE_TYPE_ID ='" + objNoticeBoardModel.btnKPI + "' ";
}
if (!string.IsNullOrWhiteSpace(objNoticeBoardModel.btnPolicy))
{
vQuery = vQuery + " and NOTICE_TYPE_ID ='" + objNoticeBoardModel.btnPolicy + "' ";
}
if (!string.IsNullOrWhiteSpace(objNoticeBoardModel.btnRecruit))
{
vQuery = vQuery + " and NOTICE_TYPE_ID ='" + objNoticeBoardModel.btnRecruit + "' ";
}
if (!string.IsNullOrWhiteSpace(objNoticeBoardModel.btnTraining))
{
vQuery = vQuery + " and NOTICE_TYPE_ID ='" + objNoticeBoardModel.btnTraining + "' ";
}
vQuery = vQuery + " ORDER BY NOTICE_DATE desc";
OracleCommand objCommand = new OracleCommand(vQuery);
OracleDataAdapter objDataAdapter = new OracleDataAdapter(objCommand);
using (OracleConnection objConnection = GetConnection())
{
try
{
objCommand.Connection = objConnection;
objConnection.Open();
objDataAdapter.Fill(objDataTable);
objDataTable.AcceptChanges();
}
catch (Exception ex)
{
throw new Exception("Error : " + ex.Message);
}
finally
{
objConnection.Close();
}
}
return(objDataTable);
}
public string SaveNotice(NoticeBoardModel objNoticeBoardModel)
{
string strMsg = "";
OracleTransaction objOracleTransaction = null;
OracleCommand objOracleCommand = new OracleCommand("pro_notice_save");
objOracleCommand.CommandType = CommandType.StoredProcedure;
if (!string.IsNullOrWhiteSpace(objNoticeBoardModel.NoticeId))
{
objOracleCommand.Parameters.Add("p_notice_id", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = objNoticeBoardModel.NoticeId;
}
else
{
objOracleCommand.Parameters.Add("p_notice_id", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = null;
}
if (!string.IsNullOrWhiteSpace(objNoticeBoardModel.NoticeTitle))
{
objOracleCommand.Parameters.Add("p_notice_title", OracleDbType.Varchar2, ParameterDirection.Input).Value = objNoticeBoardModel.NoticeTitle;
}
else
{
objOracleCommand.Parameters.Add("p_notice_title", OracleDbType.Varchar2, ParameterDirection.Input).Value = null;
}
if (objNoticeBoardModel.NoticeDate.Length > 6)
{
objOracleCommand.Parameters.Add("p_notice_date", OracleDbType.Varchar2, ParameterDirection.Input).Value = objNoticeBoardModel.NoticeDate;
}
else
{
objOracleCommand.Parameters.Add("p_notice_date", OracleDbType.Varchar2, ParameterDirection.Input).Value = null;
}
if (!string.IsNullOrWhiteSpace(objNoticeBoardModel.NoticeTypeId))
{
objOracleCommand.Parameters.Add("p_notice_type_id", OracleDbType.Varchar2, ParameterDirection.Input).Value = objNoticeBoardModel.NoticeTypeId;
}
else
{
objOracleCommand.Parameters.Add("p_notice_type_id", OracleDbType.Varchar2, ParameterDirection.Input).Value = null;
}
objOracleCommand.Parameters.Add("p_update_by", OracleDbType.Varchar2, ParameterDirection.Input).Value = objNoticeBoardModel.UpdateBy;
objOracleCommand.Parameters.Add("p_head_office_id", OracleDbType.Varchar2, ParameterDirection.Input).Value = objNoticeBoardModel.HeadOfficeId;
objOracleCommand.Parameters.Add("p_branch_office_id", OracleDbType.Varchar2, ParameterDirection.Input).Value = objNoticeBoardModel.BranchOfficeId;
objOracleCommand.Parameters.Add("P_MESSAGE", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
using (OracleConnection strConn = GetConnection())
{
try
{
objOracleCommand.Connection = strConn;
strConn.Open();
trans = strConn.BeginTransaction();
objOracleCommand.ExecuteNonQuery();
trans.Commit();
strConn.Close();
strMsg = objOracleCommand.Parameters["P_MESSAGE"].Value.ToString();
}
catch (Exception ex)
{
throw new Exception("Error : " + ex.Message);
objOracleTransaction.Rollback();
}
finally
{
strConn.Close();
}
}
return(strMsg);
}
public DataTable NoticeFileUpload(NoticeBoardModel objNoticeBoardModel)
{
//Master
DataTable dt1 = new DataTable();
string sql = "";
//sql = "SELECT " +
// "rownum sl, " +
// "TO_CHAR (NVL (NOTICE_ID,'0'))NOTICE_ID, " +
// "TO_CHAR (NVL (NOTICE_TITLE,'N/A'))NOTICE_TITLE, " +
// "TO_CHAR (NVL (NOTICE_TYPE_ID,'0'))NOTICE_TYPE_ID, " +
// "TO_CHAR(NOTICE_DATE, 'dd/mm/yyyy') NOTICE_DATE, " +
// "TO_CHAR (NVL (FILE_NAME,'N/A'))FILE_NAME " +
// " FROM VEW_NOTICE_BOARD_UPLOAD where head_office_id = '" + objNoticeBoardModel.HeadOfficeId + "' AND branch_office_id = '" + objNoticeBoardModel.BranchOfficeId + "' ";
sql = "SELECT " +
"rownum sl, " +
"NOTICE_ID, " +
"TO_CHAR (NVL (NOTICE_TITLE,'N/A'))NOTICE_TITLE, " +
"NOTICE_TYPE_ID, " +
"NOTICE_TYPE_NAME, " +
"TO_CHAR(NOTICE_DATE, 'dd/mm/yyyy') NOTICE_DATE, " +
"FILE_NAME " +
" FROM VEW_NOTICE_BOARD_UPLOAD where head_office_id = '" + objNoticeBoardModel.HeadOfficeId + "' AND branch_office_id = '" + objNoticeBoardModel.BranchOfficeId + "' ";
//"FROM VEW_BILL_OF_MATERIAL_MAIN WHERE HEAD_OFFICE_ID = '" + objTrimsModel.HeadOfficeId + "' AND BRANCH_OFFICE_ID = '" + objTrimsModel.BranchOfficeId + "' ";
if (!string.IsNullOrWhiteSpace(objNoticeBoardModel.SearchBy))
{
sql += "and ( (lower(NOTICE_TYPE_NAME) like lower( '%" + objNoticeBoardModel.SearchBy + "%') or upper(NOTICE_TYPE_NAME)like upper('%" + objNoticeBoardModel.SearchBy + "%') )" +
"or (TO_CHAR (NOTICE_DATE, 'dd/mm/yyyy') like '" + objNoticeBoardModel.SearchBy + "' or TO_CHAR (NOTICE_DATE, 'dd/mm/yyyy') like '" + objNoticeBoardModel.SearchBy + "')" +
"or (lower(NOTICE_TITLE) like lower( '%" + objNoticeBoardModel.SearchBy + "%') or upper(NOTICE_TITLE)like upper('%" + objNoticeBoardModel.SearchBy + "%') ) )";
}
sql = sql + " ORDER BY NOTICE_DATE desc";
OracleCommand objCommand = new OracleCommand(sql);
OracleDataAdapter objDataAdapter = new OracleDataAdapter(objCommand);
using (OracleConnection strConn = GetConnection())
{
try
{
objCommand.Connection = strConn;
strConn.Open();
objDataAdapter.Fill(dt1);
dt1.AcceptChanges();
}
catch (Exception ex)
{
throw new Exception("Error : " + ex.Message);
}
finally
{
strConn.Close();
}
}
return(dt1);
}
public DataTable NoticeFileUploadEdit(NoticeBoardModel objNoticeBoardModel)
{
DataTable dt2 = new DataTable();
string sql = "";
sql = "SELECT " +
"rownum sl, " +
"NOTICE_ID, " +
"NOTICE_TITLE, " +
"NOTICE_TYPE_ID, " +
"NOTICE_TYPE_NAME, " +
"TO_CHAR(NOTICE_DATE, 'dd/mm/yyyy') NOTICE_DATE, " +
"FILE_NAME " +
" FROM VEW_NOTICE_BOARD_UPLOAD where head_office_id = '" + objNoticeBoardModel.HeadOfficeId + "' AND branch_office_id = '" + objNoticeBoardModel.BranchOfficeId + "' ";
//"FROM VEW_BILL_OF_MATERIAL_SUB WHERE HEAD_OFFICE_ID = '" + objTrimsModel.HeadOfficeId + "' AND BRANCH_OFFICE_ID = '" + objTrimsModel.BranchOfficeId + "' ";
if (!string.IsNullOrEmpty(objNoticeBoardModel.NoticeId))
{
sql = sql + "and NOTICE_ID = '" + objNoticeBoardModel.NoticeId + "'";
}
if (!string.IsNullOrEmpty(objNoticeBoardModel.NoticeDate))
{
sql = sql + "and NOTICE_DATE = TO_DATE('" + objNoticeBoardModel.NoticeDate + "', 'dd/mm/yyyy')";
}
if (!string.IsNullOrEmpty(objNoticeBoardModel.NoticeTypeId))
{
sql = sql + "and NOTICE_TYPE_ID = '" + objNoticeBoardModel.NoticeTypeId + "'";
}
sql = sql + " ORDER BY NOTICE_DATE desc";
OracleCommand objCommand = new OracleCommand(sql);
OracleDataAdapter objDataAdapter = new OracleDataAdapter(objCommand);
using (OracleConnection strConn = GetConnection())
{
try
{
objCommand.Connection = strConn;
strConn.Open();
objDataAdapter.Fill(dt2);
dt2.AcceptChanges();
}
catch (Exception ex)
{
throw new Exception("Error : " + ex.Message);
}
finally
{
strConn.Close();
}
}
return(dt2);
}
