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 Delete(int ID) { IncassoSag IH = new IncassoSag(); IH.ID = ID; return(Delete(IH)); }
private static void Populate(SqlDataReader dr, IncassoSag i) { PopulateStandard(dr, i); var with_1 = i; with_1.ContactEmail = dr.DBtoString("ContactEmail"); with_1.ContactName = dr.DBtoString("ContactName"); with_1.Status = (RescueTekniq.BOL.Incasso_StatusEnum)(dr.DBtoInt("Status")); with_1.CompanyID = System.Convert.ToInt32(dr.DBtoInt("CompanyID")); with_1.InvoiceID = System.Convert.ToInt32(dr.DBtoInt("InvoiceID")); with_1.IncassoDate = System.Convert.ToDateTime(dr.DBtoDateTime("IncassoDate")); with_1.Notes = dr.DBtoString("Notes"); with_1._InvoiceTotal = System.Convert.ToDouble(dr.DBtoDouble("InvoiceTotal")); with_1.RenterOpgjortAfKreditor = System.Convert.ToDouble(dr.DBtoDouble("RenterOpgjortAfKreditor")); with_1.GebyrOpgjortAfKreditor = System.Convert.ToDouble(dr.DBtoDouble("GebyrOpgjortAfKreditor")); with_1.RenteTilskrevetFraPaymentDatetilDD = System.Convert.ToDouble(dr.DBtoDouble("RenteTilskrevetFraPaymentDatetilDD")); with_1.GebyrForDenneRykkerskrivelse = System.Convert.ToDouble(dr.DBtoDouble("GebyrForDenneRykkerskrivelse")); with_1._IncassoTotal = System.Convert.ToDouble(dr.DBtoDouble("IncassoTotal")); with_1.IncassoSalaer = dr.DBtoDouble("IncassoSalaer"); with_1.Oversendelsesgebyr = System.Convert.ToDouble(dr.DBtoDouble("Oversendelsesgebyr")); with_1.Paid = System.Convert.ToBoolean(dr.DBtoBoolean("Paid")); with_1.PaidDate = dr.DBtoDateTime("PaidDate"); }
private static void AddParms(ref DBAccess db, IncassoSag i) { var with_1 = i; db.AddNVarChar("ContactEmail", with_1.ContactEmail, 250); db.AddNVarChar("ContactName", with_1.ContactName, 50); db.AddInt("Status", (System.Int32)with_1.Status); db.AddInt("CompanyID", with_1.CompanyID); db.AddInt("InvoiceID", with_1.InvoiceID); db.AddDateTime("IncassoDate", with_1.IncassoDate); db.AddNVarChar("Notes", with_1.Notes, -1); db.AddFloat("InvoiceTotal", with_1.InvoiceTotal); db.AddFloat("RenterOpgjortAfKreditor", with_1.RenterOpgjortAfKreditor); db.AddFloat("GebyrOpgjortAfKreditor", with_1.GebyrOpgjortAfKreditor); db.AddFloat("RenteTilskrevetFraPaymentDatetilDD", with_1.RenteTilskrevetFraPaymentDatetilDD); db.AddFloat("GebyrForDenneRykkerskrivelse", with_1.GebyrForDenneRykkerskrivelse); db.AddFloat("IncassoTotal", with_1.IncassoTotal); db.AddFloat("IncassoSalaer", with_1.IncassoSalaer); db.AddFloat("Oversendelsesgebyr", with_1.Oversendelsesgebyr); db.AddBoolean("Paid", with_1.Paid); db.AddDateTime("PaidDate", with_1.PaidDate); AddParmsStandard(db, i); }
public static int Delete(IncassoSag IH) { DBAccess db = new DBAccess(); db.AddInt("ID", IH.ID); int retval = db.ExecuteNonQuery(_SQLDelete); AddLog(Status: "Incasso", Logtext: string.Format("Delete Incasso: ID:{0}", IH.ID), Metode: "Delete"); return(retval); }
public static int Update(IncassoSag c) { DBAccess db = new DBAccess(); db.AddInt("ID", c.ID); AddParms(ref db, c); int retval = db.ExecuteNonQuery(_SQLUpdate); AddLog(Status: "Incasso", Logtext: string.Format("Update Incasso: ID:{0}", c.ID), Metode: "Update"); return(retval); }
public static int Save(IncassoSag i) { int retval = 0; if (i.ID > 0) { retval = Update(i); } else { retval = Insert(i); } return(retval); }
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 IncassoSag GetIncassoByInvoiceID(int InvoiceID) { DBAccess db = new DBAccess(); IncassoSag c = new IncassoSag(); db.AddInt("InvoiceID", InvoiceID); SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectByInvoiceID)); if (dr.HasRows) { while (dr.Read()) { Populate(dr, c); } } if (!dr.IsClosed) { dr.Close(); } return(c); }
public static int Insert(IncassoSag c) { DBAccess db = new DBAccess(); AddParms(ref db, c); SqlParameter objParam = new SqlParameter("@ID", 0); objParam.Direction = ParameterDirection.Output; db.Parameters.Add(objParam); int retval = db.ExecuteNonQuery(_SQLInsert); if (retval == 1) { c.ID = Funktioner.ToInt(objParam.Value); AddLog(Status: "Incasso", Logtext: string.Format("Create Incasso: ID:{0}", c.ID), Metode: "Insert"); return(c.ID); } else { AddLog(Status: "Incasso", Logtext: string.Format("Failure to Create Incasso:"), logtype: LogTypeEnum.Error, Metode: "Insert"); return(-1); } }
public static int SetStatus(IncassoSag c) { return(SetStatus(c.ID, (Invoice_StatusEnum)c.Status)); }
public static int Purge(IncassoSag c) { return(Purge(c.ID)); }