/// <summary> /// Add a new supplier to the database /// </summary> /// <param name="supplier"></param> /// <param name="db"></param> public static void AddSupplierToTheDatabase(SupplierModel supplier, string db) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnVal(db))) { var p = new DynamicParameters(); p.Add("@PersonId", supplier.Person.Id); p.Add("@Company", supplier.Company); p.Add("@Id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output); connection.Execute("dbo.spSupplier_Create", p, commandType: CommandType.StoredProcedure); supplier.Id = p.Get <int>("@Id"); } }
/// <summary> /// Get all the incomeorders That the supplier in /// </summary> /// <param name=""></param> /// <returns></returns> public static List <IncomeOrderModel> GetIncomeOrders(SupplierModel supplier) { return(PublicVariables.IncomeOrders.FindAll(x => x.Supplier == supplier)); }