public string Get_Reqsn_Processing_Time_BY_Reqsn(string Requisition_Code)
{
return(UDFLib.CreateHtmlTableFromDataTable(BLL_PURC_Report.GET_Reqsn_Processing_Time_BY_Reqsn(Requisition_Code),
new string[] { "Quotation", "Approval", "Raise PO", "Delivery" },
new string[] { "QTN_TIME", "APP_TIME", "PO_TIME", "DLV_TIME" },
new string[] { "center", "center", "center", "center" },
"Processing Time(in days)"));
}
public void BindItems()
{
int Record_Count = 0;
int Latest = chkLatest.Checked == true ? 1 : 0;
gvPurcItems.DataSource = BLL_PURC_Report.Get_Items_Quantity_List(DDLFleet.SelectedValues, DDLVessel.SelectedValues, UDFLib.ConvertStringToNull(txtSearchItems.Text), UDFLib.ConvertStringToNull(ddlDepartment.SelectedValue),
UDFLib.ConvertStringToNull(ddlCatalogue.SelectedValue), UDFLib.ConvertStringToNull(ddlSubCatalogue.SelectedValue), UDFLib.ConvertIntegerToNull(Latest), ucpItems.CurrentPageIndex, ucpItems.PageSize, ref Record_Count);
gvPurcItems.DataBind();
ucpItems.CountTotalRec = Record_Count.ToString();
ucpItems.BuildPager();
}
public string asyncGet_Inventory_UpdatedBy(int ID, int Office_ID, int Vessel_ID)
{
UDCHyperLink aLink = new UDCHyperLink("", "../Crew/CrewDetails.aspx", new string[] { "ID" }, new string[] { "ID" }, "_blank");
Dictionary <string, UDCHyperLink> dicLink = new Dictionary <string, UDCHyperLink>();
dicLink.Add("Staff_Code", aLink);
return(UDFLib.CreateHtmlTableFromDataTable(BLL_PURC_Report.Get_Inventory_UpdatedBy(ID, Office_ID, Vessel_ID),
new string[] { "Staff Code", "Name", "Rank", "Updated On" },
new string[] { "Staff_Code", "Staff_Name", "Rank_Short_Name", "UpdatedOn" },
dicLink,
new Dictionary <string, UDCToolTip>(),
new string[] { "center", "left", "left", "left" },
"CreateHtmlTableFromDataTable-table",
"CreateHtmlTableFromDataTable-DataHedaer",
"CreateHtmlTableFromDataTable-Data"));
}
protected void btnExport_Click(object s, EventArgs e)
{
int Latest = chkLatest.Checked == true ? 1 : 0;
int Record_Count = 0;
DataTable dtItems = BLL_PURC_Report.Get_Items_Quantity_List(DDLFleet.SelectedValues, DDLVessel.SelectedValues, UDFLib.ConvertStringToNull(txtSearchItems.Text), UDFLib.ConvertStringToNull(ddlDepartment.SelectedValue),
UDFLib.ConvertStringToNull(ddlCatalogue.SelectedValue), UDFLib.ConvertStringToNull(ddlSubCatalogue.SelectedValue), UDFLib.ConvertIntegerToNull(Latest), null, null, ref Record_Count);
string[] HeaderCaptions = { };
string[] DataColumnsName = { };
string FileName = "";
string FileHeaderName = "";
HeaderCaptions = new string[] { "Vessel", "Catalogue", "Sub Catalogue", "Draw. No.", "Part Number", "Short Description", "Long Description", "Min Qty", "Max Qty", "Effective Date" };
DataColumnsName = new string[] { "Vessel_Name", "System_Description", "Subsystem_Description", "Drawing_Number", "Part_Number", "Short_Description", "Long_Description", "Min_Qty", "Max_Qty", "Effective_Date" };
FileHeaderName = "Items Min Max Quantity";
FileName = "MinMaxQuantity";
GridViewExportUtil.ShowExcel(dtItems, HeaderCaptions, DataColumnsName, FileName, FileHeaderName);
}
public int asyncUPD_Item_Quantity(int Vessel_ID, string Item_Ref_Code, int ID, decimal Min_Qty, decimal Max_Qty, string Effective_Date, int User_ID)
{
return(BLL_PURC_Report.UPD_Item_Quantity(Vessel_ID, Item_Ref_Code, ID, Min_Qty, Max_Qty, Effective_Date, User_ID));
}