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); }