public static DataSet GetAllPurchaseOrder(PurchaseOrder_StatusEnum status)
{
DBAccess db = new DBAccess();
db.AddInt("status", System.Convert.ToInt32(status));
DataSet ds = db.ExecuteDataSet(_SQLSelectByStatus);
return(ds);
}
public static DataSet GetPurchaseOrdersDS(int SupplierID, PurchaseOrder_StatusEnum Status)
{
DBAccess db = new DBAccess();
db.AddInt("SupplierID", SupplierID);
db.AddInt("Status", System.Convert.ToInt32(Status));
DataSet ds = db.ExecuteDataSet(_SQLSelectByStatusSupplier);
return(ds);
}
public static int SetStatus(int ID, PurchaseOrder_StatusEnum Status)
{
DBAccess db = new DBAccess();
PurchaseOrder c = new PurchaseOrder(ID);
db.AddInt("ID", ID);
db.AddInt("Status", System.Convert.ToInt32(Status));
AddParmsStandard(db, c);
int retval = db.ExecuteNonQuery(_SQLSetStatus);
AddLog(Status: "PurchaseOrder", Logtext: string.Format("SetStatus PurchaseOrder: ID:{0} Status:{1}", c.ID, c.StatusText), Metode: "SetStatus");
return(retval);
}
//EXEC @return_value = [vicjos1_sysadm].[Co2Db_PurchaseOrder_Search]
// @SupplierID = -1,
// @PurchaseOrderID = -1,
// @Status = -1,
// @StartDate = NULL,
// @EndDate = NULL
public static DataSet GetPurchaseOrdersSupplierDS(int SupplierID, PurchaseOrder_StatusEnum Status, int PurchaseOrderID, string StartDate, string EndDate)
{
DBAccess db = new DBAccess();
db.AddInt("SupplierID", SupplierID);
db.AddInt("PurchaseOrderID", PurchaseOrderID);
db.AddInt("Status", System.Convert.ToInt32(Status));
if (Information.IsDate(StartDate))
{
db.AddDateTime("StartDate", (DateTime?)((object)StartDate));
}
if (Information.IsDate(EndDate))
{
db.AddDateTime("EndDate", (DateTime?)((object)EndDate));
}
DataSet ds = db.ExecuteDataSet(_SQLSelectBySupplierSearch);
return(ds);
}
public static DataSet GetPurchaseOrderSupplierStatus(int SupplierID, PurchaseOrder_StatusEnum type)
{
return(Search_PurchaseOrder((System.Convert.ToInt32(type)).ToString(), SupplierID));
}
public static DataSet GetRekvireret_PurchaseOrder(PurchaseOrder_StatusEnum type)
{
return(Search_PurchaseOrder((System.Convert.ToInt32(type)).ToString()));
}
public static System.Collections.Generic.List <PurchaseOrder> GetPurchaseOrdersList(int SupplierID, PurchaseOrder_StatusEnum Status)
{
System.Collections.Generic.List <PurchaseOrder> result = new System.Collections.Generic.List <PurchaseOrder>();
DBAccess db = new DBAccess();
PurchaseOrder rec = default(PurchaseOrder);
db.AddInt("SupplierID", SupplierID);
db.AddInt("Status", System.Convert.ToInt32(Status));
SqlDataReader dr = default(SqlDataReader);
try
{
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectByStatusSupplier)); //_SQLSelectAll 'CType(db.ExecuteReader(_SQLSelectAllID), SqlDataReader)
if (dr.HasRows)
{
while (dr.Read())
{
rec = new PurchaseOrder();
Populate(dr, rec);
result.Add(rec); //(PurchaseOrder.GetPurchaseOrder(dr.DBtoInt("ID")))
}
}
dr.Close();
}
catch (Exception ex)
{
throw (ex);
}
return(result);
}