public static int UpdateStatus(int id, Invoice_StatusEnum status, int IncassoID = -1)
{
//Dim t As New InvoiceHeader(id)
//t.Status = status
//t.SetStatus()
return(SetStatus(id, status, IncassoID));
}
public static DataSet GetAllIncasso(Invoice_StatusEnum status)
{
DBAccess db = new DBAccess();
db.AddInt("status", System.Convert.ToInt32(status));
DataSet ds = db.ExecuteDataSet(_SQLSelectByStatus);
return(ds);
}
public static DataSet GetIncassoDS(int CompanyID, Invoice_StatusEnum Status)
{
DataSet ds = default(DataSet);
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
db.AddInt("Status", System.Convert.ToInt32(Status));
ds = db.ExecuteDataSet(_SQLSelectByStatusCompany);
return(ds);
}
public static int SetStatus(int ID, Invoice_StatusEnum Status)
{
DBAccess db = new DBAccess();
IncassoSag c = new IncassoSag(ID);
db.AddInt("ID", ID);
db.AddInt("Status", System.Convert.ToInt32(Status));
AddParmsStandard(db, c);
int retval = db.ExecuteNonQuery(_SQLSetStatus);
AddLog(Status: "Incasso", Logtext: string.Format("SetStatus Incasso: ID:{0} Status:{1}", c.ID, c.StatusText), Metode: "SetStatus");
return(retval);
}
public static DataSet GetIncassoCompanyStatus(int CompanyID, Invoice_StatusEnum type)
{
return(Search_Incasso((System.Convert.ToInt32(type)).ToString(), CompanyID));
}
public static DataSet GetRekvireret_Invoice(Invoice_StatusEnum type)
{
return(Search_Incasso((System.Convert.ToInt32(type)).ToString()));
}
public static System.Collections.Generic.List <IncassoSag> GetIncassoList(int CompanyID, Invoice_StatusEnum Status)
{
System.Collections.Generic.List <IncassoSag> result = new System.Collections.Generic.List <IncassoSag>();
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
db.AddInt("Status", System.Convert.ToInt32(Status));
SqlDataReader dr = default(SqlDataReader);
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectByStatusCompany));
if (dr.HasRows)
{
while (dr.Read())
{
result.Add(IncassoSag.GetIncasso(System.Convert.ToInt32(dr.DBtoInt("ID"))));
}
}
if (!dr.IsClosed)
{
dr.Close();
}
return(result);
}
public static int UpdateStatus(int id, Invoice_StatusEnum status)
{
return(SetStatus(id, status));
}
public static System.Collections.Generic.List <InvoiceHeader> GetInvoiceList(int CompanyID, Invoice_StatusEnum Status, int EANInvoice)
{
System.Collections.Generic.List <InvoiceHeader> result = new System.Collections.Generic.List <InvoiceHeader>();
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
db.AddInt("Status", System.Convert.ToInt32(Status));
db.AddInt("EANInvoice", EANInvoice);
System.Data.SqlClient.SqlDataReader dr = default(System.Data.SqlClient.SqlDataReader);
try
{
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectByStatusCompany)); //_SQLSelectAll 'CType(db.ExecuteReader(_SQLSelectAllID), SqlDataReader)
if (dr.HasRows)
{
while (dr.Read())
{
result.Add(InvoiceHeader.GetInvoice(System.Convert.ToInt32(dr.DBtoInt("ID"))));
}
}
dr.Close();
}
catch (Exception ex)
{
throw (ex);
}
return(result);
}
