// add new request
public static RequestDto AddNewRequest(RequestDto requestDto)
{
try
{
// converts the URL to a recording format
requestDto.content = "VERSION BUILD = 1005 RECORDER = CR\nURL GOTO = " + requestDto.content + " \nSAVEAS TYPE = HTML FOLDER =D:\\Files FILE =newHtml";
requestDto.recording_stream = Encoding.ASCII.GetBytes(requestDto.content);
Status status = Run(requestDto.content, "");
// Robotic surfing for keeping the initial state of the page
if (status == Status.sOk)
{
// Read the page content
string newPlay = File.ReadAllText("D:\\Files\\newHtml.htm");
// fill in the data
requestDto.file_stream = Encoding.ASCII.GetBytes(newPlay);
requestDto.file_id = RequestDAL.AttachedFile(requestDto.file_stream, ".html");
// add to database
RequestDto requestsDto = RequestDAL.AddNewRequest(requestDto);
return(requestsDto);
}
}
catch (Exception)
{
return(null);
}
return(null);
}
/// <summary>
/// Date Created: 06/10/2011
/// Created By: Josephine Gad
/// (description) Get list of hotel/vehicle request
/// ---------------------------------------------
/// </summary>
/// <param name="DateFrom"></param>
/// <param name="DateTo"></param>
/// <param name="UserID"></param>
/// <param name="RegionID"></param>
/// <param name="CountryID"></param>
/// <param name="CityID"></param>
/// <param name="Status"></param>
/// <param name="FilterByNameID"></param>
/// <param name="FilterNameID"></param>
/// <param name="PortID"></param>
/// <param name="HotelID"></param>
/// <param name="VehicleID"></param>
/// <param name="VesselID"></param>
/// <param name="Nationality"></param>
/// <param name="Gender"></param>
/// <param name="Rank"></param>
/// <param name="Approved"></param>
/// <returns></returns>
public static DataTable GetRequest(string DateFrom, string DateTo,
string UserID, string RegionID, string CountryID, string CityID,
string Status, string FilterByNameID, string FilterNameID, string PortID,
string HotelID, string VehicleID, string VesselID, string Nationality,
string Gender, string Rank, string Approved, string Role)
{
DataTable dt = null;
try
{
dt = RequestDAL.GetRequest(DateFrom, DateTo, UserID, RegionID, CountryID,
CityID, Status, FilterByNameID, FilterNameID, PortID, HotelID, GlobalCode.Field2Int(VehicleID).ToString(),
VesselID, Nationality, Gender, Rank, Approved, Role);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
// GET api/<controller>/5
//public string Get(int id)
//{
// return "value";
//}
public IEnumerable <RequestData> GetRequestByUser(string name)
{
RequestDAL dal = new RequestDAL();
List <RequestData> listData = dal.GetRequest(name);
return(listData);
}
protected void btnSend_Click(object sender, EventArgs e)
{
if (fileUpload.HasFile == true)
{
RequestData data = new RequestData();
data.ApproveID = ddlApprove.SelectedItem.Value;
data.Subject = txtSubject.Text;
data.Description = txtDescription.Text;
data.CreateBy = hdUserName.Value;
data.Path_File = path_file + fileUpload.PostedFile.FileName;
RequestDAL dal = new RequestDAL();
string req_Id = hdReqIdStock.Value;
bool check = dal.RequestInsert(data, req_Id);
if (check == true)
{
string fileName = Path.GetFileName(fileUpload.PostedFile.FileName);
fileUpload.PostedFile.SaveAs(Server.MapPath(path_file) + fileName);
this.Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "myscript", "Message_Show('Save Success')", true);
Response.Redirect("DisplayStock.aspx?ReqId=" + req_Id);
}
}
else
{
//เป็นฟังก์ชัน javascript เรียกที่ main.master
//RegisterClientScriptBlock(typeof(Page), "myscript", "ชื่อฟังก์ชัน", true);
this.Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "myscript", "Message_Show('กรุณาอัพโหลดไฟล์')", true);
}
}//btnSend_Click
protected void btnDelete_Click(object sender, EventArgs e)
{
//เมื่อกดปุ่ม btnDelete ให้ฟอร์มแก้ไขหาย
pnl_eidt.Visible = false;
//เมื่อกดปุ่มลบ จะแปลงค่าให้อยู่ในรูปแบบของ ImageButton
Button btnImg = sender as Button;
//เเปลง ImageButton ให้อยู่ในรูปของ GridViewRow
GridViewRow gRow = (GridViewRow)btnImg.NamingContainer;
//get ค่า DataKeyNames="RequestID"
string request_id = ResultGridView.DataKeys[gRow.RowIndex].Value.ToString();
if (request_id != "")
{
RequestDAL dal = new RequestDAL();
bool cehck_delete = dal.RequestDelete(request_id);
if (cehck_delete == true)
{
this.Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "myscript", "Message_Show('Delete_Success')", true);
string username = HiddenField1.Value;
DisplayRequest(username);
}
}
}
}//GetHost
protected void btnEdit_Click(object sender, EventArgs e)
{
pnl_eidt.Visible = true;
Button btnEdit = sender as Button;
GridViewRow gRow = (GridViewRow)btnEdit.NamingContainer;
string request_id = ResultGridView.DataKeys[gRow.RowIndex].Value.ToString();
if (request_id != "")
{
RequestDAL dal = new RequestDAL();
RequestData data = dal.GetRequestId(request_id);
if (data != null)
{
txtRequestId.Text = data.RequestID;
txtSubject.Text = data.Subject;
txtDescription.Text = data.Description;
txtNote.Text = data.Note;
}
}
}
protected void btnLinQ_Click(object sender, EventArgs e)
{
RequestDAL dal = new RequestDAL();
string dt = txtDt.Text;
DataSet ds = dal.GetRequest(dt, null);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
DataTable dataTB = ds.Tables[0];
var dataRow = dataTB.AsEnumerable().Where(x => x.Field <string>("REQUEST_ID") == txtSearch.Text);
DataTable result = dataRow.CopyToDataTable <DataRow>();
if (result != null && result.Rows.Count > 0)
{
ResultGridView.DataSource = result;
ResultGridView.DataBind();
}
else
{
ResultGridView.DataSource = null;
ResultGridView.DataBind();
}
}
}
// GET api/<controller>
//public IEnumerable<string> Get()
//{
// return new string[] { "value1", "value2" };
//}
public IEnumerable <RequestData> GetRequestAll()
{
RequestDAL dal = new RequestDAL();
List <RequestData> listData = dal.GetRequestAll();
return(listData);
}
public List <RequestDTO> GetRequests()
{
var requests = RequestDAL.GetRequests();
if (requests == null)
{
return(null);
}
return(Map <List <RequestDTO> >(requests));
}
public RequestDTO GetRequest(RequestDTO request)
{
var requests = RequestDAL.GetRequest(Map <Request>(request));
if (requests == null)
{
return(null);
}
return(Map <RequestDTO>(requests));
}
public List <RequestDTO> GetRequestsForDivision(string divisionId)
{
var requests = RequestDAL.GetRequestsForDivision(divisionId);
if (requests == null)
{
return(null);
}
return(Map <List <RequestDTO> >(requests));
}
public List <RequestDTO> GetRequests(int divisionId)
{
var requests = RequestDAL.GetRequests(divisionId);
if (requests == null)
{
return(null);
}
return(Map <List <RequestDTO> >(requests));
}
/// <summary>
/// Date Created: 04/10/2011
/// Created By: Josephine Gad
/// (description) Update hotel/vehicle request
/// ---------------------------------------------
/// </summary>
/// <param name="RequestID"></param>
/// <param name="SeafarerId"></param>
/// <param name="VesselId"></param>
/// <param name="OnOffDate"></param>
/// <param name="Status"></param>
/// <param name="IsNeedHotel"></param>
/// <param name="BranchID"></param>
/// <param name="CheckInDate"></param>
/// <param name="CheckOutDate"></param>
/// <param name="IsNeedTransportation"></param>
/// <param name="Origin"></param>
/// <param name="OriginRemarks"></param>
/// <param name="Destination"></param>
/// <param name="DestinationRemarks"></param>
/// <param name="PickupDate"></param>
/// <param name="PortId"></param>
/// <param name="CityID"></param>
/// <param name="PortAgentId"></param>
/// <param name="CostCenterID"></param>
/// <param name="RankID"></param>
/// <param name="User"></param>
public static void RequestUpdate(string RequestID, string SeafarerId,
string VesselId, string OnOffDate, string Status, bool IsNeedHotel,
string BranchID, string CheckInDate, string CheckOutDate, bool IsNeedTransportation,
string Origin, string OriginRemarks, string Destination, string DestinationRemarks, string PickupDate,
string PortId, string CityID, string PortAgentId, string CostCenterID, string RankID,
string User)
{
RequestDAL.RequestUpdate(RequestID, SeafarerId, VesselId, OnOffDate, Status,
IsNeedHotel, BranchID, CheckInDate, CheckOutDate, IsNeedTransportation,
Origin, OriginRemarks, Destination, DestinationRemarks, PickupDate, PortId, CityID,
PortAgentId, CostCenterID, RankID, User);
}
private void DisplayRequest(string username)
{
RequestDAL dal = new RequestDAL();
List <RequestData> listresult = dal.GetRequest(username);
if (listresult != null && listresult.Count > 0)
{
ResultGridView.DataSource = listresult;
ResultGridView.DataBind();
}
}
public bool UpdateRequest(TnkLfeRequest request)
{
int affectedRows = RequestDAL.UpdateRequest(request);
if (affectedRows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// Date Created: 06/10/2011
/// Created By: Josephine Gad
/// (description) Get hotel/vehicle request details by Request ID
/// ---------------------------------------------
/// Date Modified: 28/11/2011
/// Modified By: Charlene Remotigue
/// (description) optimization (use datareader instead of datatable
/// </summary>
/// <param name="RequestID"></param>
/// <returns></returns>
public static IDataReader GetRequestDetailsByID(string RequestID)
{
IDataReader dt = null;
try
{
dt = RequestDAL.GetRequestDetailsByID(RequestID);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <RequestDto> GetAllRelevantRequests(EventLog eventLog)
{
try
{
eventLog.WriteEntry("BL:In GetAllRelevantRequests.");
List <RequestDto> requestDtos = RequestDAL.GetAllRelevantRequests(eventLog);
return(requestDtos);
}
catch (Exception ex)
{
eventLog.WriteEntry(ex.ToString());
return(null);
}
}
// adding a recording - is called from the extension without filling request details yet
public static int AddNewRecording(RequestDto requestDto)
{
try
{
//Chaining to Record A command that will save the page as HTML
requestDto.content += " \nSAVEAS TYPE = HTML FOLDER =D:\\Files FILE =newHtml";
requestDto.recording_stream = Encoding.ASCII.GetBytes(requestDto.content);
// add to database
return(RequestDAL.AddNewRecording(requestDto));
}
catch (Exception)
{
return(-1);
throw;
}
}
public TnkLfeRequest GetRequest(int id)
{
DataSet ds = RequestDAL.GetRequests(id);
TnkLfeRequest requet = new TnkLfeRequest();
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
requet.Id = Convert.ToInt32(dr["Id"]);
requet.Requester = Convert.ToString(dr["Requester"]);
requet.Summary = Convert.ToString(dr["Summary"]);
requet.Description = Convert.ToString(dr["Description"]);
}
}
return(requet);
}
private void sendButton_Click(object sender, EventArgs e)
{
string toRoom = toRoomCombobox.SelectedValue.ToString();
string toSlot = toSlotCombobox.SelectedValue.ToString();
if (toRoom == "" || toSlot == "")
{
MessageBox.Show("Destination of Room and Slot required!", "Inform", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else if (!isNumberic(toSlot))
{
MessageBox.Show("Slot have to be an integer!", "Inform", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else if (!(new RoomDAL().isRoomExisted(toRoom)))
{
MessageBox.Show("This room is not existed", "Inform", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
DataTable availableRoom = new RoomDAL().getAvailableRoomByInput(toRoom);
if (!(availableRoom.Rows.Count > 0))
{
message.Text = "Room " + toRoom + " is full";
return;
}
else
{
// insert
bool successInsert = new RequestDAL().addChangeRoomRequest(theStudent.studentID, slotField.Text, roomField.Text, contentField.Text, toSlot, toRoom, "1");
if (successInsert)
{
MessageBox.Show("Request has sent!", "Inform", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
MessageBox.Show("Send fail", "Inform", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
string[] data_arr = new string[3];
data_arr[0] = txtSearch.Text;
data_arr[1] = txtSearcjNameSubject.Text;
data_arr[2] = txtDt.Text;
RequestDAL dal = new RequestDAL();
List <RequestData> listResult = dal.GetRequest(data_arr);
if (listResult != null && listResult.Count > 0)
{
ResultGridView.DataSource = listResult;
ResultGridView.DataBind();
}
}
public List <TnkLfeRequest> GetRequests()
{
List <TnkLfeRequest> requets = new List <TnkLfeRequest>();
DataSet ds = RequestDAL.GetRequests();
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
TnkLfeRequest requet = new TnkLfeRequest();
requet.Requester = Convert.ToString(dr["Requester"]);
requet.Summary = Convert.ToString(dr["Summary"]);
requet.Description = Convert.ToString(dr["Description"]);
requet.Id = Convert.ToInt32(dr["Id"]);
requets.Add(requet);
}
}
return(requets);
}
// update request details - Recording was done through the extension
public static RequestDto UpdateRequestFromTheExtension(RequestDto requestDto)
{
try
{
if (requestDto.recording_id == new Guid())
{
RequestDto requestsDto = RequestDAL.FillInDataRequest(requestDto);
Status status = Run(Encoding.UTF8.GetString(requestsDto.recording_stream), "");
if (status == Status.sOk)
{
string newPlay = File.ReadAllText("D:\\Files\\newHtml.htm");
RequestDAL.UpdateHtmlFile(requestsDto, newPlay);
}
}
}
catch (Exception)
{
throw;
}
return(requestDto);
}
private void sendButton_Click(object sender, EventArgs e)
{
var confirmResult = MessageBox.Show("Do you really want to leave? \nYour request will be sent to the dom't manager", "Confirm", MessageBoxButtons.YesNo);
if (confirmResult == DialogResult.No)
{
return;
}
else
{
bool successInsert = new RequestDAL().addLeaveRoomRequest(theStudent.studentID, slotField.Text, roomField.Text, "1");
if (successInsert)
{
MessageBox.Show("Request has sent", "Done", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
MessageBox.Show("Send fail", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
// GET: WF
public ActionResult Index()
{
EmployeeDATA employeeDATA = new EmployeeDATA();
RequestDATA requestDATA = new RequestDATA();
if (Session["userid"] != null)
{
string userid = Session["userid"].ToString();
EmployeeDAL employeeDAL = new EmployeeDAL();
employeeDATA = employeeDAL.GetUserInfo(userid);
if (employeeDATA != null)
{
RequestDAL requestDAL = new RequestDAL();
List <RequestDATA> listData = requestDAL.GetRequestByUserId(userid);
requestDATA.LSTREQ = listData;
//แปลงเป็น JSON
string json = JsonConvert.SerializeObject(requestDATA);
requestDATA.JSON = json;
//แปลงเป็น OBJECT
requestDATA = JsonConvert.DeserializeObject <RequestDATA>(json);
if (requestDATA.LSTREQ.Count > 0)
{
ViewData["REQDATA"] = requestDATA.LSTREQ;
}
}
}
return(View(employeeDATA));
}
protected void btnSave_Click(object sender, EventArgs e)
{
RequestData data = new RequestData();
data.RequestID = txtRequestId.Text;
data.Subject = txtSubject.Text;
data.Description = txtDescription.Text;
data.Note = txtNote.Text;
data.Status = "Reject";
RequestDAL dal = new RequestDAL();
#region update request table
bool check_request = dal.RequestUpdate(data);
#endregion
#region update request_reject table
bool check_request_reject = dal.RequestRejectInsert(data);
#endregion
if (check_request == true && check_request_reject == true)
{
this.Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "myscript", "Message_Show('Save_success')", true);
string username = HiddenField1.Value;
DisplayRequest(username);
}
else
{
this.Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "myscript", "Message_Show('Error')", true);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (contentField.Text == "")
{
MessageBox.Show("Content can't be empty!", "Inform", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
// insert to database
bool successInsert = new RequestDAL().addComplain(theStudent.studentID, slotField.Text, roomField.Text, contentField.Text, "1");
if (successInsert)
{
MessageBox.Show("Request has sent!", "Inform", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
MessageBox.Show("Send fail", "Inform", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
}
public static void OnInitMapper()
{
RequestDAL.OnInitMapper();
}
//public static RequestDto UpdateRequest(RequestDto requestDto)
//{
// RequestDto requestsDto = RequestDAL.UpdateRequest(requestDto);
// return requestsDto;
//}
//public static RequestDto DeleteRequest(RequestDto requestDto)
//{
// return RequestDAL.DeleteRequest(requestDto);
//}
public static List <RequestDto> DeleteRequest(RequestDto requestDto)
{
return(RequestDAL.DeleteRequest(requestDto));
}
public static List <RequestDto> UpdateRequest(RequestDto requestDto)
{
List <RequestDto> requestsDto = RequestDAL.UpdateRequest(requestDto);
return(requestsDto);
}
