public static int Get_Inventory_Item_List_Count(int Fleet,
int Vessel_ID,
string Department_Code,
string System_Code,
string Subsystem_Code,
string Part_Number,
string Drawing_Number,
string Short_Description,
string FROMDATE,
string TODATE,
int Inventory_Qty,
int Latest
)
{
return(DAL_PURC_Common.Get_Inventory_Item_List_Count_DL(
Fleet,
Vessel_ID,
Department_Code,
System_Code,
Subsystem_Code,
Part_Number,
Drawing_Number,
Short_Description,
FROMDATE,
TODATE,
Inventory_Qty,
Latest
));
}
public static int Get_Active_PO_Count(string Order_Code)
{
try
{
return(DAL_PURC_Common.PURC_Get_Active_PO_Count(Order_Code));
}
catch
{
throw;
}
}
public static int PURC_UPD_CancelPO_FilePath(string OrderCode, string FileName, string FilePath, string Remark, int UserID)
{
try
{
return(DAL_PURC_Common.PURC_UPD_CancelPO_FilePath(OrderCode, FileName, FilePath, Remark, UserID));
}
catch
{
throw;
}
}
public static DataTable Get_GradingType()
{
try
{
return(DAL_PURC_Common.Get_GradingType());
}
catch
{
throw;
}
}
public static int INS_UPD_DEL_Question(int?ID, string Question, int?Grading_Type, int?Type_ID, int UserID, string Mode)
{
try
{
return(DAL_PURC_Common.INS_UPD_DEL_Question_DL(ID, Question, Grading_Type, Type_ID, UserID, Mode));
}
catch
{
throw;
}
}
public static DataTable Get_QuestionList(string searchtext, string dept)
{
try
{
return(DAL_PURC_Common.Get_QuestionList_DL(searchtext, dept));
}
catch
{
throw;
}
}
public static DataTable Get_GradingOptions(int Grade_ID)
{
try
{
return(DAL_PURC_Common.Get_GradingOptions_DL(Grade_ID));
}
catch
{
throw;
}
}
public static int INS_UPD_DEL_GradingOption(int Grade_ID, string OptionText, decimal OptionValue, int UserID)
{
try
{
return(DAL_PURC_Common.INS_UPD_DEL_GradingOption_DL(Grade_ID, OptionText, OptionValue, UserID));
}
catch
{
throw;
}
}
public static int INS_UPD_DEL_Grading(int?ID, string Grading_Name, int?Grade_Type, int?Min, int?Max, int?Divisions, int UserID, string Mode)
{
try
{
return(DAL_PURC_Common.INS_UPD_DEL_Grading_DL(ID, Grading_Name, Grade_Type, Min, Max, Divisions, UserID, Mode));
}
catch
{
throw;
}
}
public static DataTable Get_Purc_Items(string Reqsn_Code)
{
try
{
return(DAL_PURC_Common.Get_Purc_Items(Reqsn_Code));
}
catch
{
throw;
}
}
public static DataTable Get_Inventory_Item_List(int Fleet,
int Vessel_ID,
string Department_Code,
string System_Code,
string Subsystem_Code,
string Part_Number,
string Drawing_Number,
string Short_Description,
string FROMDATE,
string TODATE,
int Inventory_Qty,
int Latest,
int?Inventory_Qty_Less,
int?Inventory_Qty_Greater,
int PageIndex,
int PageSize,
int isCritical,
ref int IsFetch_Count
)
{
return(DAL_PURC_Common.Get_Inventory_Item_List_DL(
Fleet,
Vessel_ID,
Department_Code,
System_Code,
Subsystem_Code,
Part_Number,
Drawing_Number,
Short_Description,
FROMDATE,
TODATE,
Inventory_Qty,
Latest,
Inventory_Qty_Less,
Inventory_Qty_Greater,
PageIndex,
PageSize,
isCritical,
ref IsFetch_Count
));
}
public static DataTable Get_User_Vessel_Assign(int Vessel_ID, int UserID)
{
return(DAL_PURC_Common.Get_User_Vessel_Assign(Vessel_ID, UserID));
}
public static DataTable Get_Function(int UserID, int ReqsnType)
{
return(DAL_PURC_Common.Get_Function(UserID, ReqsnType));
}
public static DataTable Get_CancelReqsn_DL_New(string fleetid, string vesselcode, string depttype, string deptcode, string req_order_code, string potype, string acctype, string reqsntype, string catalogue, string FromDate, string ToDate, string accClass, string dtUrgency, string reqstatus, int?pageindex, int?pagesize, ref int isfetchcount, string Sort_By, string Sort_Direction)
{
return(DAL_PURC_Common.Get_CancelReqsn_DL_New(fleetid, vesselcode, depttype, deptcode
, req_order_code, potype, acctype, reqsntype, catalogue, FromDate, ToDate, accClass, dtUrgency, reqstatus, pageindex, pagesize, ref isfetchcount, Sort_By, Sort_Direction));
}
public static DataTable Get_POItem_ToCancel(string OrderCode)
{
return(DAL_PURC_Common.Get_POItem_ToCancel_DL(OrderCode));
}
public static DataSet PURC_INS_Duplicate_RequisitionDeatils(string DocumentCode, int VESSEL_CODE, int Delivery_Port, string Delivery_Date, int UserID, string user_Name)
{
return(DAL_PURC_Common.PURC_INS_Duplicate_RequisitionDeatils(DocumentCode, VESSEL_CODE, Delivery_Port, Delivery_Date, UserID, user_Name));
}
public static DataTable GET_ItemType(string QuotationCode, string ItemRefCode)
{
return(DAL_PURC_Common.GET_ItemType_DL(QuotationCode, ItemRefCode));
}
public static DataTable Get_CancelReqsn(DataTable fleetid, DataTable vesselcode, string depttype, DataTable deptcode
, int?reqsntype, string req_order_code, int?pageindex, int?pagesize, ref int isfetchcount, string Sort_By, string Sort_Direction)
{
return(DAL_PURC_Common.Get_CancelReqsn_DL(fleetid, vesselcode, depttype, deptcode, reqsntype, req_order_code, pageindex, pagesize, ref isfetchcount, Sort_By, Sort_Direction));
}
public static int UPDATE_CancelPOItems(string OrderCode, string Remark, int UserId, string ItemID)
{
return(DAL_PURC_Common.UPDATE_CancelPOItems_DL(OrderCode, Remark, UserId, ItemID));
}
public static DataTable PURC_Get_UserTypeAccess(int UserID, string Variable_Type)
{
return(DAL_PURC_Common.PURC_Get_UserTypeAccess(UserID, Variable_Type));
}
public static DataTable PURC_Get_ItemCategory(int UserID, string FilterType)
{
return(DAL_PURC_Common.PURC_Get_ItemCategory(UserID, FilterType));
}
public static DataTable PURC_Get_PO_Type(int UserID, string AccessType)
{
return(DAL_PURC_Common.PURC_Get_PO_Type(UserID, AccessType));
}
public static DataTable GET_Buyer_Remarks(string DocCode)
{
return(DAL_PURC_Common.GET_Buyer_Remarks(DocCode));
}
public static DataTable PURC_Get_Supplier_Type(int UserID, string FilterType)
{
return(DAL_PURC_Common.PURC_Get_Supplier_Type(UserID, FilterType));
}
public static DataTable Get_CancelReqsn(int?fleetid, int?vesselcode, string depttype, string deptcode
, int?reqsntype, string req_order_code, int?pageindex, int?pagesize, ref int isfetchcount)
{
return(DAL_PURC_Common.Get_CancelReqsn_DL(fleetid, vesselcode, depttype, deptcode, reqsntype, req_order_code, pageindex, pagesize, ref isfetchcount));
}
public static DataSet PURC_Get_Requisition_Type(string PO_Type, int?User_ID)
{
return(DAL_PURC_Common.PURC_Get_Requisition_Type(PO_Type, User_ID));
}
public static DataTable Get_RFQ_Supplier(string Reqsncode)
{
return(DAL_PURC_Common.Get_RFQ_Supplier_DL(Reqsncode));
}
public static DataSet Filter_Catalog(int?UserID, string Function_Type)
{
return(DAL_PURC_Common.Filter_Catalog(UserID, Function_Type));
}
public static DataTable GET_ItemTypeAll(string QuotationCode)
{
return(DAL_PURC_Common.GET_ItemTypeAll_DL(QuotationCode));
}
public static DataSet PURC_Filter_AccountClassification(int?UserID, string FilterType, string Reqn_Type)
{
return(DAL_PURC_Common.PURC_Filter_AccountClassification(UserID, FilterType, Reqn_Type));
}