public bookRoomMasterModel master(bookRoomModel value)
{
bookRoomMasterModel result = new bookRoomMasterModel();
try
{
using (var context = new StandardCanEntities())
{
if (String.IsNullOrEmpty(value.user_id))
{
throw new Exception("Unauthorized Access");
}
var userId = JwtHelper.GetUserIdFromToken(value.user_id);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
string sql = "select convert(nvarchar(5), MRM_ID) code ";
sql += " , MRM_CODE [text] ";
sql += " from MAS_ROOM ";
sql += " order by MRM_CODE ";
result.room = context.Database.SqlQuery <dropdown>(sql).ToList();
sql = " select convert(nvarchar(5), MAS_ID) code, mas_name [text] ";
sql += " from MAS_APPROVE_STATUS ";
sql += " where MAS_ID != 0 ";
sql += " order by mas_orderby ";
result.status = context.Database.SqlQuery <dropdown>(sql).ToList();
}
//if (myOutputParamInt.Value != null)
//{
// int r_id = Convert.ToInt32(myOutputParamInt.Value);
// result.status = "S";
// result.message = "";
// result.value = r_id.ToString();
//}
//else
//{
// result.status = "E";
// result.message = "";
//}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(result);
}
// POST: api/bookRoom
public HttpResponseMessage Post([FromBody] bookRoomModel value)
{
if (value == null)
{
return(null);
}
JavaScriptSerializer js = new JavaScriptSerializer();
bookRoomService service = new bookRoomService();
HttpResponseMessage response = null;
Object result = null;
switch (value.method)
{
case "master":
result = service.master(value);
break;
case "search":
result = service.search(value);
break;
case "search_all_calendar":
result = service.search_all_calendar(value);
break;
case "search_room_calendar":
result = service.search_room_calendar(value);
break;
case "detail":
result = service.detail(value);
break;
default:
break;
}
string json = js.Serialize(result);
response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(json, System.Text.Encoding.UTF8, "application/json");
return(response);
}
public calendarMeetingRoomViewModel search_room_calendar(bookRoomModel value)
{
try
{
calendarMeetingRoomViewModel result = new calendarMeetingRoomViewModel();
result.dataList = new List <sp_bookroom_calendar_Result>();
using (StandardCanEntities context = new StandardCanEntities())
{
var masRoom = context.MAS_ROOM.SingleOrDefault(a => a.MRM_ID.ToString() == value.id);
result.roomName = masRoom?.MRM_NAME;
result.dataList = context.sp_bookroom_calendar(value.id, value.user_id).ToList();
var qrCodeRawData = result.dataList.FirstOrDefault(a => a.isCurrent == "1");
if (qrCodeRawData != null)
{
var qrCodeData = String.Format("{0},{1},{2},{3}", value.id, DateTime.Now.ToString("dd/MM/yyyy"), qrCodeRawData.time_start, qrCodeRawData.time_stop);
QRCodeGenerator _qrCode = new QRCodeGenerator();
QRCodeData _qrCodeData = _qrCode.CreateQrCode(qrCodeData, QRCodeGenerator.ECCLevel.Q);
QRCode qrCode = new QRCode(_qrCodeData);
Bitmap qrCodeImage = qrCode.GetGraphic(20);
var microsoftDateFormatSettings = new JsonSerializerSettings
{
DateParseHandling = DateParseHandling.None,
DateFormatHandling = DateFormatHandling.IsoDateFormat,
Formatting = Formatting.Indented,
};
Bitmap newBitmap;
newBitmap = new Bitmap(qrCodeImage);
byte[] fileBytes = BitmapToBytesCode(newBitmap);
result.qrCode = Convert.ToBase64String(fileBytes, 0, fileBytes.Length);
result.roomTopic = qrCodeRawData.topic;
}
return(result);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public bookRoomMasterModel master(bookRoomModel value)
{
try
{
bookRoomMasterModel result = new bookRoomMasterModel();
using (var context = new StandardCanEntities())
{
if (String.IsNullOrEmpty(value.user_id))
{
throw new Exception("Unauthorized Access");
}
var userId = JwtHelper.GetUserIdFromToken(value.user_id);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
string sql = "select convert(nvarchar(5), mrm_id) code ";
sql += " , mrm_name [text] ";
sql += " from MAS_ROOM ";
sql += " order by mrm_name ";
result.room = context.Database.SqlQuery <dropdown>(sql).ToList();
sql = " select convert(nvarchar(5), MAS_ID) code, mas_name [text] ";
sql += " from MAS_APPROVE_STATUS ";
sql += " where MAS_ID != 0 ";
sql += " order by mas_orderby ";
result.status = context.Database.SqlQuery <dropdown>(sql).ToList();
}
return(result);
}
catch (Exception ex)
{
//result.status = "E";
//result.message = ex.Message.ToString();
throw new Exception(ex.Message);
}
}
public IEnumerable <sp_bookroom_search_v3_Result> search_all_calendar(bookRoomModel value)
{
try
{
if (String.IsNullOrEmpty(value.user_id))
{
throw new Exception("Unauthorized Access");
}
var userId = JwtHelper.GetUserIdFromToken(value.user_id);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
StandardCanEntities context = new StandardCanEntities();
IEnumerable <sp_bookroom_search_v3_Result> result = context.sp_bookroom_search_v3(value.room_from, value.room_to, value.date_from, value.date_to, value.status_from, value.status_to, "all").AsEnumerable();
return(result);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public bookRoomDetailModel detail(bookRoomModel value)
{
bookRoomDetailModel result = new bookRoomDetailModel();
try
{
using (var context = new StandardCanEntities())
{
if (String.IsNullOrEmpty(value.user_id))
{
throw new Exception("Unauthorized Access");
}
var userId = JwtHelper.GetUserIdFromToken(value.user_id);
var userGroup = JwtHelper.GetUserGroupFromToken(value.user_id);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
if (userGroup == "1" || userGroup == "2" || userGroup == "4")
{
result.button.reject = false;
result.button.approve = false;
result.button.cancel = true;
result.button.save_draft = true;
result.button.save_send = true;
}
else if (userGroup == "3")
{
result.button.reject = true;
result.button.approve = true;
result.button.cancel = true;
result.button.save_revise = true;
result.button.save_draft = true;
result.button.save_send = false;
}
string sql = "select convert(nvarchar(5), mrm_id) code ";
sql += " , mrm_code [text] ";
sql += " from MAS_ROOM ";
sql += " where MRM_STATUS=1";
sql += " order by mrm_name ";
result.room_list = context.Database.SqlQuery <dropdown>(sql).ToList();
if (string.IsNullOrEmpty(value.id))
{
sql = "select convert(nvarchar(3), MHW_ID) id ";
sql += " , MHW_NAME text ";
sql += ", convert(bit, 0) opt ";
sql += " from MAS_HARDWARE ";
sql += " where MHW_STATUS = 1";
result.device_list = context.Database.SqlQuery <checkbox_list>(sql).ToList();
result.button.reject = false;
result.button.cancel = false;
result.button.save_revise = false;
}
else
{
sql = "select convert(nvarchar(3), a.MHW_ID) id ";
sql += " , MHW_NAME text ";
sql += ", convert(bit, case when b.MHW_ID is null then 0 else 1 end ) opt ";
sql += " from MAS_HARDWARE a left join BOOK_ROOM_DEVICE b on a.MHW_ID=b.MHW_ID and b.BR_ID= " + value.id;
sql += " where MHW_STATUS = 1";
result.device_list = context.Database.SqlQuery <checkbox_list>(sql).ToList();
result.emp_list = context.sp_bookroom_emp(value.id).ToList();
var h = context.BOOK_ROOM.Where(p => p.BR_ID.ToString().Equals(value.id)).FirstOrDefault();
if (h != null)
{
var mas_room = context.MAS_ROOM.SingleOrDefault(a => a.MRM_ID == h.MRM_ID);
result.id = h.BR_ID.ToString();
result.room_name = mas_room != null ? mas_room.MRM_NAME : "";
result.topic = h.br_topic ?? "";
result.date = h.br_date == null ? "" : Convert.ToDateTime(h.br_date).ToString("dd/MM/yyyy");
result.start_time = h.br_start_time ?? "";
result.stop_time = h.br_stop_time ?? "";
result.person_total = h.br_person_total == null ? "" : h.br_person_total.ToString();
result.room_id = h.MRM_ID == null ? "" : h.MRM_ID.ToString();
result.remark = h.br_remark ?? "";
result.br_status = h.br_status.ToString();
if (h.br_request_by != null)
{
result.br_request = h.br_request_by.ToString();
var emp_request = context.EMP_PROFILE.SingleOrDefault(a => a.emp_code == h.br_request_by.ToString());
if (emp_request != null)
{
result.br_request_name = emp_request.emp_fname + " " + emp_request.emp_lname;
}
}
if (h.br_status == 1)
{
result.read_only = true;
result.button.reject = false;
result.button.approve = false;
result.button.save_revise = false;
result.button.cancel = false;
result.button.save_draft = false;
result.button.save_send = false;
if (userGroup == "3")
{
result.button.reject = true;
result.button.approve = true;
result.button.save_draft = true;
result.button.cancel = false;
result.button.save_revise = false;
result.button.save_send = false;
result.read_only = false;
}
if (h.br_create_by.ToString() == userId)
{
result.read_only = false;
result.button.save_draft = true;
if (userGroup != "3")
{
result.button.cancel = true;
result.button.save_send = true;
}
}
}
else if (h.br_status == 2)
{
result.button.cancel = false;
result.button.save_draft = false;
result.button.save_send = false;
if (userGroup == "3")
{
result.button.save_revise = true;
}
else
{
result.button.save_revise = false;
}
if (h.br_create_by.ToString() == userId)
{
result.button.cancel = true;
}
result.read_only = true;
}
else if (h.br_status == 0 || h.br_status == 3 || h.br_status == 4 || h.br_status == 5)
{
result.button.reject = false;
result.button.approve = false;
result.button.cancel = false;
result.button.save_draft = false;
result.button.save_send = false;
if (userGroup == "3")
{
result.button.save_revise = true;
}
else
{
result.button.save_revise = false;
}
result.read_only = true;
if (h.br_status == 3)
{
result.button.gen_qrCode = true;
}
}
}
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(result);
}
