protected void AjaxFileUpload1_OnUploadComplete(object sender, AjaxFileUploadEventArgs file)
{
try
{
BLL_Tec_Inspection objTechService = new BLL_Tec_Inspection();
Byte[] fileBytes = file.GetContents();
string sPath = Server.MapPath("\\" + System.Configuration.ConfigurationManager.AppSettings["APP_NAME"].ToString() + "\\uploads\\Technical");
Guid GUID = Guid.NewGuid();
string Flag_Attach = GUID.ToString() + Path.GetExtension(file.FileName);
string FullFilename = Path.Combine(sPath, GUID.ToString() + Path.GetExtension(file.FileName));
int sts = objTechService.SaveAttachedFileInfo(Request.QueryString["VESSEL_ID"].ToString(), Request.QueryString["InspectionDetailId"].ToString(), Path.GetFileName(file.FileName), UDFLib.Remove_Special_Characters(Path.GetFileName(FullFilename)), Session["USERID"].ToString());
FileStream fileStream = new FileStream(FullFilename, FileMode.Create, FileAccess.ReadWrite);
fileStream.Write(fileBytes, 0, fileBytes.Length);
fileStream.Close();
// ScriptManager.RegisterStartupScript(this, typeof(Page), "refresh", "fn_OnClose(a,b)", true);
}
catch (Exception ex)
{
}
}
public void BindInspAttchment()
{
BLL_Tec_Inspection objInsp = new BLL_Tec_Inspection();
DataTable dtAttachment = objInsp.INSP_Get_Attachments_DL(Request.QueryString["InspectionDetailId"].ToString(), Convert.ToInt32(Request.QueryString["Vessel_Id"].ToString()));
gvInspectionAttachment.DataSource = dtAttachment;
gvInspectionAttachment.DataBind();
}
public void imgbtnDelete_Click(object s, EventArgs e)
{
try
{
BLL_Tec_Inspection objAttch = new BLL_Tec_Inspection();
string[] arg = (((ImageButton)s).CommandArgument.Split(new char[] { ',' }));
int res = objAttch.INSP_Delete_Attachments_DL(int.Parse(arg[0]), int.Parse(arg[1]), UDFLib.ConvertToInteger(Session["USERID"]));
BindInspAttchment();
}
catch
{ }
}
public string CreateHtmlTableFromDataTable(DataTable dtTable, string[] HeaderCaptions, string[] DataColumnsName, string[] ColumnsWidth, string PageHeader)
{
StringBuilder strTable = new StringBuilder();
try
{
if (dtTable.Rows.Count > 0)
{
strTable.Append("<table id='__tbl_remark' class='CreateHtmlTableFromDataTable-table' CELLPADDING='2' CELLSPACING='0' style='border-collapse:collapse' >");
if (PageHeader.Length > 1)
{
strTable.Append("<tr> <td class='CreateHtmlTableFromDataTable-PageHeader' colspan='" + dtTable.Columns.Count + "' > <b>" + PageHeader + "</b> </td></tr>");
}
if (HeaderCaptions.Length > 0)
{
strTable.Append("<tr >");
for (int i = 0; i < HeaderCaptions.Length; i++)
{
strTable.Append("<td class='CreateHtmlTableFromDataTable-DataHedaer' width='" + ColumnsWidth[i] + "'>");
strTable.Append("<b>" + HeaderCaptions[i] + "</b>");
strTable.Append("</td>");
}
strTable.Append("</tr>");
}
foreach (DataRow dr in dtTable.Rows)
{
strTable.Append("<tr>");
for (int i = 0; i < DataColumnsName.Length; i++)
{
if (i == 0 || i == 4 || i == 6 || i == 5)
{
strTable.Append("<td class='CreateHtmlTableFromDataTable-Data' style='White-space:normal;width:" + ColumnsWidth[i] + ";text-align:center;'>");
strTable.Append(dr[DataColumnsName[i]].ToString().Replace("\n", "<br>"));
strTable.Append("</td>");
}
else
{
strTable.Append("<td class='CreateHtmlTableFromDataTable-Data' style='White-space:normal;width:" + ColumnsWidth[i] + "'>");
strTable.Append(dr[DataColumnsName[i]].ToString().Replace("\n", "<br>"));
strTable.Append("</td>");
}
}
strTable.Append("</tr>");
// Attachment//
BLL_Tec_Inspection objBLL = new BLL_Tec_Inspection();
DataTable dt = objBLL.Get_Worklist_Attachments(Convert.ToInt32(dr["Vessel_ID"]), Convert.ToInt32(dr["Worklist_id"]), Convert.ToInt32(dr["OFFICE_ID"]), 0);
DataView dvImage = dt.DefaultView;
dvImage.RowFilter = "Is_Image='1' ";
strTable.Append("<tr>");
strTable.Append("<td colspan='" + DataColumnsName.Length.ToString() + "' class='CreateHtmlTableFromDataTable-Data' style='background-color:#F0F0F0; '>");
int imgRun = 1;
foreach (DataRow drimg in dvImage.ToTable().Rows)
{
strTable.Append("<a href='" + Request.Url.Scheme + "://" + Request.Url.Authority + Request.ApplicationPath.TrimEnd('/') + "/" + "uploads/technical/" + drimg["Image_Path"].ToString() + "'><img src='" + Request.Url.Scheme + "://" + Request.Url.Authority + Request.ApplicationPath.TrimEnd('/') + "/" + "uploads/technical/" + drimg["Image_Path"].ToString() + "' alt='' height='250' width='250px' style='margin:5px;' ></a>");
if (imgRun == 3)
{
strTable.Append("</td>");
strTable.Append("</tr>");
strTable.Append("<tr>");
strTable.Append("<td colspan='" + DataColumnsName.Length.ToString() + "' class='CreateHtmlTableFromDataTable-Data'>");
imgRun = 1;
}
imgRun++;
}
strTable.Append("</td>");
strTable.Append("</tr>");
//attachment/
}
strTable.Append("</table>");
}
else
{
strTable.Append("<span style='color:maroon;padding:2px'> No record found !</span>");
}
return(strTable.ToString());
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
protected string Search_Worklist(string LocationID, string LocationNodeID, string InspID)
{
try
{
string response = "";
BLL_Tec_Inspection objInsp1 = new BLL_Tec_Inspection();
DataTable dtFilter = new DataTable();
dtFilter.Columns.Add("PRM_NAME", typeof(string));
dtFilter.Columns.Add("PRM_VALUE", typeof(object));
dtFilter.Rows.Add(new object[] { "@FLEET_ID", UDFLib.ConvertIntegerToNull(null) });
dtFilter.Rows.Add(new object[] { "@VESSEL_ID", UDFLib.ConvertIntegerToNull(ViewState["Vessel_ID"]) });
dtFilter.Rows.Add(new object[] { "@ASSIGNOR", UDFLib.ConvertIntegerToNull(null) });
dtFilter.Rows.Add(new object[] { "@DEPT_SHIP", UDFLib.ConvertIntegerToNull(null) });
dtFilter.Rows.Add(new object[] { "@DEPT_OFFICE", UDFLib.ConvertIntegerToNull(null) });
dtFilter.Rows.Add(new object[] { "@PRIORITY", UDFLib.ConvertIntegerToNull(null) });
dtFilter.Rows.Add(new object[] { "@CATEGORY_NATURE", UDFLib.ConvertIntegerToNull(null) });
dtFilter.Rows.Add(new object[] { "@CATEGORY_PRIMARY", UDFLib.ConvertIntegerToNull(null) });
dtFilter.Rows.Add(new object[] { "@CATEGORY_SECONDARY", UDFLib.ConvertIntegerToNull(null) });
dtFilter.Rows.Add(new object[] { "@CATEGORY_MINOR", null, });
dtFilter.Rows.Add(new object[] { "@JOB_DESCRIPTION", UDFLib.ConvertStringToNull(null) });
dtFilter.Rows.Add(new object[] { "@JOB_STATUS", UDFLib.ConvertStringToNull(null) });
dtFilter.Rows.Add(new object[] { "@JOB_TYPE", UDFLib.ConvertIntegerToNull(null) });
dtFilter.Rows.Add(new object[] { "@PIC", UDFLib.ConvertIntegerToNull(null) });
dtFilter.Rows.Add(new object[] { "@JOB_MODIFIED_IN", UDFLib.ConvertIntegerToNull(null) });
dtFilter.Rows.Add(new object[] { "@DATE_RAISED_FROM", UDFLib.ConvertDateToNull(null) });
dtFilter.Rows.Add(new object[] { "@DATE_RAISED_TO", UDFLib.ConvertDateToNull(null) });
dtFilter.Rows.Add(new object[] { "@DATE_CMPLTN_FROM", UDFLib.ConvertDateToNull(null) });
dtFilter.Rows.Add(new object[] { "@DATE_CMPLTN_TO", UDFLib.ConvertDateToNull(null) });
dtFilter.Rows.Add(new object[] { "@DEFER_TO_DD", (null) });
dtFilter.Rows.Add(new object[] { "@SENT_TO_SHIP", (null) });
dtFilter.Rows.Add(new object[] { "@HAVING_REQ_NO", (null) });
dtFilter.Rows.Add(new object[] { "@FLAGGED_FOR_MEETING", (null) });
dtFilter.Rows.Add(new object[] { "@INSPECTOR", UDFLib.ConvertIntegerToNull(null) });
dtFilter.Rows.Add(new object[] { "@PAGE_INDEX", (null) });
dtFilter.Rows.Add(new object[] { "@PAGE_SIZE", (null) });
dtFilter.Rows.Add(new object[] { "@LOCATION_ID", UDFLib.ConvertIntegerToNull(LocationID) });
dtFilter.Rows.Add(new object[] { "@NODE_ID", UDFLib.ConvertIntegerToNull(LocationNodeID) });
dtFilter.Rows.Add(new object[] { "@InspectionID", UDFLib.ConvertIntegerToNull(InspID) });
int Record_Count = 0;
DataSet taskTable = objInsp1.INSP_Get_Worklist(dtFilter, ref Record_Count);
if (taskTable.Tables.Count > 0)
{
if (taskTable.Tables[0].Rows.Count > 0)
{
string strTable = CreateHtmlTableFromDataTable(taskTable.Tables[0], new string[] { "Job Code", "DESCRIPTION", "DATE RAISED", "Dept. On Ship", "TYPE", "PRIORITY", "STATUS" }, new string[] { "WLID_DISPLAY", "JOB_DESCRIPTION", "DATE_RAISED", "ONSHIP_DEPT", "Type", "PRIORITY", "WORKLIST_STATUS" }, new string[] { "50px", "300px", "70px", "100px", "120px", "100px", "100px" }, "");
response = strTable;
}
}
return(response);
}
catch (Exception ex)
{
string js = "alert('Error in loading data!! Error: " + UDFLib.ReplaceSpecialCharacter(ex.Message) + "');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true);
return("");
}
}
protected bool Save_Schedule()
{
try
{
if (ValidateAll() == true)
{
DataTable dtSchedule = NewDaemonScheduleTable();
DataTable dtSettings = NewDaemonSettingTable();
DataTable dtChecklist = NewDaemonChecklist();
DataTable dtPortList = NewDaemonPortList();
Populate_Schedular_Table(dtSchedule);
Populate_Settings_Table(dtSettings);
dtSettings.DefaultView.RowFilter = "Key_Name='Onetime'";
if (dtSettings.DefaultView.ToTable().Rows.Count > 0)
{
string strdate = Convert.ToDateTime(dtSettings.DefaultView.ToTable().Rows[0]["Key_Value_Date"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
int response1 = 0;
int response = objInsp.CheckExists_Schedule(Convert.ToInt32(dtSchedule.Rows[0]["InspectorID"].ToString()), strdate, Convert.ToInt32(dtSchedule.Rows[0]["DurJobs"].ToString()), GetSessionUserID(), response1);
if (response == -5)
{
string js = "alert('Schedule already exists.');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "script1", js, true);
return(false);
}
}
Populate_Checklist_Table(dtChecklist);
dtPortList.Rows.Add(drpPort.SelectedValue.ToString());
int Res;
if (Request.QueryString["ScheduleID"] != null)
{
Res = objInsp.Save_Schedule(dtSchedule, dtSettings, dtChecklist, GetSessionUserID(), UDFLib.ConvertToInteger(Request.QueryString["SchDetailId"].ToString()), dtPortList);
}
else
{
Res = objInsp.Save_Schedule(dtSchedule, dtSettings, dtChecklist, GetSessionUserID(), null, dtPortList);
if (Request.QueryString["Page"] != null && Request.QueryString["VesselID"] != null && Request.QueryString["Surv_Details_ID"] != null && Request.QueryString["Surv_Vessel_ID"] != null && Request.QueryString["OfficeID"] != null)
{
if (Res > 0)
{
objInsp = new BLL_Tec_Inspection();
objInsp.SurveyRenewalInspection(UDFLib.ConvertToInteger(Request.QueryString["Surv_Details_ID"]), UDFLib.ConvertToInteger(Request.QueryString["Surv_Vessel_ID"]), UDFLib.ConvertToInteger(Request.QueryString["VesselID"]), UDFLib.ConvertToInteger(Request.QueryString["OfficeID"]), Res, ref ReturnInspectionID);
}
}
}
if (Res == -1)
{
string js = "alert('Schedule name already exists.');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "script1", js, true);
return(false);
}
else if (Res > 0)
{
ViewState["ScheduleID"] = Res.ToString();
ViewState["ScheduleID"] = ViewState["ScheduleID"];
return(true);
}
else
{
return(false); // procedure
}
}
else
{
return(false); // Validation false
}
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
return(false);
}
}
