public int SaveToNoticeBoard(NoticeDepartmentVIewModel model, Database db, DbTransaction trans)
{
var errMessage = string.Empty;
var queryParamList = new QueryParamList
{
new QueryParamObj {
ParamDirection = ParameterDirection.Input, ParamName = "@Id", ParamValue = model.Id, DBType = DbType.String
},
new QueryParamObj {
ParamDirection = ParameterDirection.Input, ParamName = "@Details", ParamValue = model.Details
},
new QueryParamObj {
ParamDirection = ParameterDirection.Input, ParamName = "@PostingDate", ParamValue = DateTime.UtcNow, DBType = DbType.DateTime
},
new QueryParamObj {
ParamDirection = ParameterDirection.Input, ParamName = "@ImageFileName", ParamValue = model.ImageFileName
},
new QueryParamObj {
ParamDirection = ParameterDirection.Input, ParamName = "@CreatedBy", ParamValue = model.CreatedBy
},
new QueryParamObj {
ParamDirection = ParameterDirection.Input, ParamName = "@CompanyId", ParamValue = model.CompanyId
},
new QueryParamObj {
ParamDirection = ParameterDirection.Input, ParamName = "@CreateDate", ParamValue = DateTime.UtcNow, DBType = DbType.DateTime
},
};
const string sql = @"INSERT INTO ResourceTracker_NoticeBoard (Id, Details, PostingDate, ImageFileName, CreatedBy, CreateDate,CompanyId) VALUES( @Id, @Details, @PostingDate,@ImageFileName, @CreatedBy, @CreateDate,@CompanyId)";
return(DBExecCommandExTran(sql, queryParamList, trans, db, ref errMessage));
}
public IHttpActionResult Approved(int id, string userId)
{
var response = _leaveRepository.Approved(id, userId);
if (response.Success)
{
var result = _leaveRepository.GetLeaveById(id).First();
if (result.IsApproved && !result.IsRejected)
{
var noticeBoard = new NoticeDepartmentVIewModel
{
Details = string.Format("{0} is taking leave from {1} to {2}.", result.EmployeeName, result.FromDate.ToString(Constants.DateLongFormat), result.ToDate.ToString(Constants.DateLongFormat)),
PostingDate = DateTime.Now.ToString(),
CompanyId = result.CompanyId,
CreatedBy = result.ApprovedById,
CreateDate = DateTime.Now.ToString()
};
var noticeResponse = _noticeBoardRepository.CreateNoticeBoard(noticeBoard);
_attendance.AddAttendanceAsLeave(new AttendanceEntryModel
{
UserId = userId,
CompanyId = result.CompanyId
});
}
}
return(Ok(response));
}
public IHttpActionResult SaveNoticeBoard(JObject jObject)
{
dynamic json = jObject;
var noticeBoard = new NoticeDepartmentVIewModel
{
Details = json.Details,
ImageFileName = json.ImageFileName,
CompanyId = json.CompanyId,
CreatedBy = json.CreatedBy
};
var response = _noticeBoardRepository.CreateNoticeBoard(noticeBoard);
return(Ok(response));
}
public NoticeDepartmentVIewModel CreateNoticeBoard(NoticeDepartmentVIewModel model)
{
var err = string.Empty;
Database db = GetSQLDatabase();
var returnId = -1;
using (DbConnection conn = db.CreateConnection())
{
conn.Open();
DbTransaction trans = conn.BeginTransaction();
try
{
model.Id = Guid.NewGuid().ToString();
returnId = SaveToNoticeBoard(model, db, trans);
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
err = ex.Message;
}
}
return(model);
}
